I have two tables, one for questions, the other (a child) for responses. They were working fine until I combined the question table with another table, which then changed the ID so that the answers no longer correspond. How do I get the child table to to automatically update the foreign key numbers? There is no text to compare such as "A = B." THe only thing to compare are the Old ID/FK numbers. Thanks for any help.
You need a subForm.
Use the form wizard, to build a master form to show 1 master record,
And a sub form to show the many children.
The sub form will link on the key field and automatically add the FK to the child table.