Insert Into Heeelllllllp!!!!

[Derek]

How do I insert records into a table that is the many side
of a one to many relationship.

 

[John Vinson]

How do I insert records into a table that is the many side
of a one to many relationship.

From where? Could you give us a little help on the context?

Normally one would use a Form based on the "one" side table, with a
Subform based on the "many", using the linking field as the
Master/Child Link Field of the subform.

 

[Derek]

Hi John

THat's exactly it I need to duplicate and append a
complete set of records from a main form and all records
in the subform. This so that I can quickly add a new
record that has many fields and only change the few fields
that make a new record like the order date for a repeat
order.

 

[John Vinson]

Hi John

THat's exactly it I need to duplicate and append a
complete set of records from a main form and all records
in the subform. This so that I can quickly add a new
record that has many fields and only change the few fields
that make a new record like the order date for a repeat
order.

Two append queries, run from code on a command button, should do this.
What specific problems are you having? What have you tried?

 

[Derek]

Hi John

I am assuming that if I choose the main form record first
and append the record to its underlying table, that the
new record will generate a new number in the counter field
of the main form table. As this is also the referencial
integrity linking field to the subform table when I append
records from the subform it needs the new linking field
number in the main table to allow the appending of new
records to the subform table. how will it know the number
of the linking field? Am I missing something simple?