Access Engine Could not find key matching field error

[hrdpgajjar]

HI all,
i am trying to create a simple order system. done all relationship and sub form matching field. but still got error as per attachment. I am trying to learn this thing so pls guide me what i am doing wrong. I have attached my database and query screenshot.



Thank You,

 

[CJ_London]

non of the queries generate an error - suggest advise how to replicate the error

 

[hrdpgajjar]

non of the queries generate an error - suggest advise how to replicate the error

open "View Customer Form" and try to add more than one items in subform,

 

[arnelgp]

Open your View Customer Form and test it.

 

[hrdpgajjar]

Open your View Customer Form and test it.

Thanks for the effort. why it is not working as i need? i mean to open "View Customer Form" And add products on subform? what is the problem doing it?

You can take a look at the file i have made earlier,

FDMS

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

it works in my FDMS File but not work here. what exactly is the problem ? or it is just access bug?
thanks

 

[arnelgp]

And add products on subform? w

Order Detail Table needs that an OrderID must be found in Order Table (which must be open since you have Linked fields there).

 

[hrdpgajjar]

Order Detail Table needs that an OrderID must be found in Order Table (which must be open since you have Linked fields there).

Did u take a look at the FDMS File i have attached? i am trying to do the same thing here, but not worked? what is wrong?

 

[CJ_London]

You have not attached a file, you have provided a web link
. And have you tried Arnel's suggestion - in essence you have too many tables in your subform query

 

[hrdpgajjar]

You have not attached a file, you have provided a web link
. And have you tried Arnel's suggestion - in essence you have too many tables in your subform query

my file size is too big to attach here, so i've shared it via media fire. Ofcourse i've tried Arnel's suggestion but its not what i want.

 

[CJ_London]

Now cross posted here

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

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...

www.accessforums.net