Order form query

[crossy5575]

Hi all,
sorry this is a really easy one, and i should know what to do but i cant!
basically i have 2 tables - firstly tblproductsdb - a data store of all the products I sell...
secondly is tblorderprods - this is a table used in conjunction with tblproductsdb (as a query) so that the customer can order select a product listed (not a drop down but all the products are shown.), from which I can then filter once the order is made to show only selected products and tick them off when they arrive from my supplier...

easy....

what i am trying to do is build a query shown as the ideal query table, however when i combine tblorderprods and tblproductsdb i dont show any records as there are no similar records.

prodcutsdb is used in other areas of the db and i only want to have one products database... can anyone help please?

regards

Simon

 

[plog]

You have no data in tblorderprodsdetail, so there's no data to return.

What do you expect the query to return?

 

[crossy5575]

Hi Plog,
what i want is for the query to show exactly what is in the table - ideal query.

ie all the data in tblorderprodsdetail and blank 2 columns of purchasequantity and purchasedelivered.

The user can then populate the query I can filter requested codes and add the data to a bigger order.
in most order forms you can have a cell looking up all the fields, however I want them shown a a field.
hope this makes more sense.
Simon

 

[jdraw]

Get you tables and relationships set up and tested before getting too deep into Access coding.
You have Order, OrderDetail and Products. But I would expect Customer to be in the database, but you know your requirements and business better then the readers.
This generic model re Customers, Order and products may be helpful to you.
Good luck with your project.

 

[plog]

Actually, no. Little of that made sense.

ie all the data in tblorderprodsdetail and blank 2 columns of purchasequantity and purchasedelivered.

That almost made sense, except for the fact that like I said before--you have no data in tblorderprodsdetail. So in a way, you are getting what you asked for.

Perhaps you can demonstrate what you want to appear with sample data. Based on the data in that sample database you uploaded shwo me what exact data you expect to be i n your query.