relation problem between Mainform-Subform?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Suppose that there are two related tables by just one field. Relation
type is one-to-many relation: enforce referantial integrity enabled,
Cascade Update disabled, Cascade Delete disabled.
Say that Table1 has ONE, Table2 has MANY side of the relation.
My target is to creat a columnar form by table1 and insert a tabular
subform by table2. So that, link child fields and link master fields
are to be set on the field by which relation is established.
By using navigation buttons, i can switch to next record on the Table1
and all related itemsin the Table2 automatically to be seen in the
tabular subform. So, I can edit any value in the tabular subform.
To make this process faster, I changed the edit box in the Main form
(by which relation is established) into ComboBox, so I can get the
desired record faster. However, I CAN NOT edit subform because of such
error message "The record can not be deleted or changed because
Table2 includes related records".
Is there a way to swich another record by ComboBox instead of
navigation button?
I need to access the Table2 record as fas as possible, by using the
Table1.

Thanks

.

Relevant Pages

  • Re: double data entry with msgbox function?
    ... loop through the fields in Table2 comparing each field to its corresponding ... Table1.Do you Wish To Edit One Of The Tables?",vbYesNo,"Field Values Don't ... <Code To Edit Table1> ... Need a month calendar or 7 day calendar? ...
    (comp.databases.ms-access)
  • Editing more than 1 table at a time with SQL.
    ... Say I have two tables in a DB called TABLE1, and TABLE2. ... My question is would I be able to use SQL in code to Edit, ...
    (microsoft.public.access.modulesdaovba)
  • Re: DBLookupComboBox question
    ... > For the sake of example, the table I'm reading from is table1, and the ... > DataField -> recordID ... the edit part doesn't display anything. ... > active, and table2 is in edit ...
    (comp.lang.pascal.delphi.misc)
  • gridview for two tables
    ... while data from table2 is allowed for edit and ... columns from table1 be configurated non-editable and non-deletable in the ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Tricky Visual Basic Code help...
    ... moves the current record into a new record in table2. ... this with a little VBA code and a couple custom queries. ... Set a "pushFlag" column in the record in table1 to a specific ... If a duplicate is not found, ...
    (microsoft.public.access.formscoding)