Duplicate records created using a two subforms in a main form (1 Viewer)

[wire_jp]

I have created a database in microsoft access 2010 to show invoices for different customers in different countries. In doing so, I created using a two subforms in a main form. I have used the "country name" to link the subforms to the main form. When I enter new records into the subforms for a specific country, I realized that a duplicate record of an old record are being created in the subforms. What can I do to prevent this from happening? I tried to change the query link between the main form and subform to "invoice number" but the same problem has occurred.

P.S. I am novice to microsoft access 2010 and any help will be greatly appreciated.

 

[burrina]

Normally you link the subforms by your Primary Key and Fake Key. See if this fixes your problem.

 

[wire_jp]

when you say "fake key", do you mean "foreign key"?

 

[burrina]

Yes, they are one in the same. People refer to them in different ways. but YES...
Good Luck!