Solved 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

 

[GPGeorge]

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.

Hm. "...not what I want."

Sometimes, when working with a relational database, we have to relinquish "what we want" and adopt "what actually works". The nature of relational database dictates what is, and what is not, effective.

Is that possibly the case here?

I am referring to the subform design in which you have multiple tables in the query which is the recordsource for a subform.

As a general principle, for data entry purposes, forms and subforms should be based on tables or on queries with one table when possible. The more complex a query becomes, the more likely it is to fail as a recordsource for a data entry form or subform.

I suggest you take a look at the alternative ArnelGP offered.

 

[hrdpgajjar]

Hm. "...not what I want."

Sometimes, when working with a relational database, we have to relinquish "what we want" and adopt "what actually works". The nature of relational database dictates what is, and what is not, effective.

Is that possibly the case here?

I am referring to the subform design in which you have multiple tables in the query which is the recordsource for a subform.

As a general principle, for data entry purposes, forms and subforms should be based on tables or on queries with one table when possible. The more complex a query becomes, the more likely it is to fail as a recordsource for a data entry form or subform.

I suggest you take a look at the alternative ArnelGP offered.

I have followed the exact path. anyways removing one table and linking customer table to Orderdetails table solve my problem instantly.

 

[mike60smart]

I have followed the exact path. anyways removing one table and linking customer table to Orderdetails table solve my problem instantly.

Take a look at your exact same question on AccessForums. I have given you the correct method of solving your problem.