Access Database engine can not find a record in table with key matching fields

[hrdpgajjar]

Hi all,


i am learning access. And tried to make purchase order system. I have done all the data normalization and relationship.

Now,
I have created a form named "ViewCustomerF" and it has a subform named with link of "CustomerID" field.

Whenever i tried to add data to related sub form, it gives an error as per attached screenshot.

below is my database file ( I am not able to attach here so sharing via mediafire link)

https://www.mediafire.com/file/cv0u4...tem.accdb/file

what i am doing wrong? pls help


Thanks

[June7]

That download is not working for me. Many will not download from external site. Attach file to post. Follow instructions at bottom of my post.

[jojowhite]

there is a cross-posting here:
Access Engine Could not find key matching field error | Access World Forums

[mike60smart]

Your structure is Customer - Orders - Items

So the basic layout of the Main Form is based on the Customer table with a Subform based on the Orders Table.

Then you have a second Subform based on the OrderDetails Table.

See the modified db attached.

[Damin]

Check your relationships, the way you're linking fields, and make sure the CustomerID exists in the main form before trying to add data in the subform.