Query Nightmare

[Deonh]

Hello everyone

I seem to be on the side of the loosing team when it comes to access.

currently i am using access 2007 and 2010.
The problem i am having is after i have build my database i am trying to query it when i do the stock and location query every thing seems to work just fine but the moment i build the query to place an order to take the stock off nothing seems to work my queries fields is blocked i can enter any data in the fields , and when i build a form from the query it is a blank form i am attaching my Db for you to see if you can see where i am going wrong.
The problem is in qryCustomerOrder and the for for query.
Thanks in advance for all your time and help in the matter

Deon

 

[plog]

You're tables look fine, but I can't really see what you are trying to do with your forms though. I do see an error with them.

Right now, no data is showing up in the form qryCustomOrder (misleading prefix to use with a form by the way) because the query qryCustomerOrder has no results. That query has no results because you have no related records in 3 of your tables (Customer, InkCustomer_order_Product and tblCustomer_Order). You have no data in those tables as a matter of fact. The way that query is structured is that you must have matching data for a record in all those tables, because some tables have no data, the entire thing is failing to show anything.

However, you're forms are set up incorrectly. Forms that you want to modify data (add/edit/delete) shouldn't be based on queries, but on tables. You can find out more about the proper way to set up forms in the Forms section of this forum, but yours are fundamentally flawed for that reason.

 

[Deonh]

Thank you for the information i new that the problem i am having is my doing i just did not know where to start looking for it thanks again for the insight much appreciated

 

[jdraw]

You have no Customer records, so there can't be records in related tables.
No Customers - No Orders -???
Build some test records to match your business rules.
Test your test records against your tables and relationships.
Make sure your tables and relationships match your requirements.
Then work on getting data in and out of the database.