The Microsoft Access database engine cannot find a record in the table [TableName] with key matching field(s) [PrimaryKeyFieldName]

I have normalized a single table database into 3NF (i.e. multiple tables), but notice when I try to add a new record to the main table, I get the above error message.  My question is: how do I get the Primary Key of the new record in the main table to populate tables related by that Primary Key? (i.e. how do I enter the Primary Key ONCE and have it appear in each related table?)

Hey Tom,

Sorry, not a longtime Access user.  My database doesn't have any subforms.  It has one main table "Member" with an AutoNumber Primary Key, to which 4 other tables are related.  The form I'm using queries the tables for all fields needed for data entry (I've changed "Data Entry" in the "Property Sheet" to Yes). Is there a way to set this up so that ANY insert/update to the main table Primary Key is propagated to all related tables as Foreign Keys?

It sounds like you are trying to enter data into 5 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.

Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2010 Blog: Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries
Hope this helps,
Microsoft Access MVP since 2007

6 people found this reply helpful

Was this reply helpful?


Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.


Question Info

Last updated August 3, 2021 Views 8,042 Applies to: