Form won't accept new records - referential integrity problem - 1 to many tables (1 Viewer)

[Gordon]

I have created a form which allows the entry (or should) of data into two tables, via a query. The tables are linked in a one to many relationship. I can view the existing data, but cannot add new records. I get an error message which states that "a related record is required in the Household table." Problem is, I am trying to create this record through the form!

Any help would be most welcome!

Gordon

 

[Bru]

You will find rapid sucess with the addition of a subform for the child table records. The problem with using a single query to enter data into a one to many relationship is the parent record will have to be repeated for every entry in the child table.

The add subform command button will fire up the subform wizard. If it is not available in the toolbars selection, you may have to install all of the wizards and advanced options from the access/office CD Rom.
Hope this helps
Bru