Are these two tables joined together in the Relationships window with
Referiential Integrity enabled? If not you may have problems.
Probably the best way to add records in this situation is a form for the
parent table and a subform based on the child table. When you add a record to
the child table, Access should automatically link it to the parent table.
This will work if you have RI enabled as above and let the Wizard install the
subform.
