Have main form with an unbound subform1 which is used for data entry.
Subform1 has a nested continuous unbound subform (subform2) which is used to
enter multiple records related to the record being entered in subform1.
Am using DAO method to save the records entered into subform1 & 2 into the
underlying tables (table1 & table2).
Record being entered in subform1 only gets its unique identifier when saved
to underlying table (primary key field is autonumber).
Any suggestions on best way to set up saving the related records in table2
(i.e. get the key field from the related record being saved in table1).
Prefer user to enter data in subform1 & 2 in one step and then press a save
button which will save the record to table1 and the related records to
table2.
Any suggestions greatly appreciated.
Bob