auto numbers and new records

[batman26]

I have 2 tables that are set up in a 1-to-many relationship and has “Force Referential Integrity” selected. These tables form a query that is the record source for a form that has part of is data input handled by another form that uses 4 combo boxes where each combo rowsource is determined by the preceding combo (except the first). The data is saved in variables and then set to the value of the fields on the main form.
The problem is that I cannot set the values in the main form because there hasn’t been a record created in the 1-side table. Is there a way to cause the table to start a new record and except the data?

 

[Pat Hartman]

The normal setup for a 1-to-many relationship is a main form based on a query of the 1-side table and a subform based on a query of the many-side table. The main form is filled in and when the cursor is moved to the subform, the mainform looses focus causing the 1-side record to be saved. This enables records of the subform to be added since they have a main form record to relate to.

With RI enforced, which is the absolutely correct thing to do, there is no way to add a row to the many-side table without having a 1-side table that it relates to.