Form isn't reading table records I am really new at building databases. I created a table that reads from other tables. However, I needed to add another table and I placed the input field into the form.

My problem is that the form isn't reading any of the records already on the tables. How did this change and how do I fix it?

Now every time I enter a new record this message comes up.


  The Microsoft database engine can not find a record in the table "  " with key matching fields "  "
This is a common error. Either you screwed up the 1:M relationship or you are trying to enter data into multiple tables incorrectly


From Microsoft's Developer Network MSDN :In a one-to-many relationship, you entered data on the "many" side for which there is no matching record on the "one" side. For example, this error occurs if you join a Customers table and Orders table on a CustomerID field, and then add an order using a CustomerID that does not exist in the Customers table.
From Microsoft Answers: It sounds like you are trying to enter data into multiple tables using one main form. That's not going to work. You NEED to be using subforms. Create your main form bound to the Members table and then subforms to each of the child tables. Use the Form wizard to create your forms.


My guess from your comments is #2. You added a new table but didn't recreate the form using subforms.