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?)
Answer
Answer

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: http://scottgem.spaces.live.com/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,
Scott<>
Blog: http://scottgem.wordpress.com
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 November 20, 2020 Views 7,433 Applies to: