Query/Forms

[e51lrrp]

I have a POS database that I have been working on for quite a while and have a situation that I cannot get past. I would appreciate anyone's input to have me. The situation is this.. I have a tblCustomer, tblOrders and several table details. The one that I am having a problem with is frmApparelOrderDetail. I want to be able to populate the frmApparelOrderDetail with information from the frmOrders. I have established the relationship between these tables and the query is LEFT joined. But when I try to fill out the detail form it gives me a new OrderID every time I try put in multiple items. This form has been a real problem for some time and I just modified the SQL statement to make sure the OrderID was being pulled from the tblApparelOrderDetail not tblOrders. This solved one problem but created this new situation.



I have attached my database to this post in hopes that someone will be able to help me. Also I have limited data listed as I am almost ready to put REAL data in and deleted all the test data.

Sure hope someone can assist me. Sharon

[burrina]

Can you explain how your database is supposed to work, step by step? I see you have frmNewApparelOrderDetail and using the values of frmOrders for your criteria. Normally that would be a DLookup instead. What if that form (frmOrders) is not open, then what?

[e51lrrp]

Can you explain how your database is supposed to work, step by step? I see you have frmNewApparelOrderDetail and using the values of frmOrders for your criteria. Normally that would be a DLookup instead. What if that form (frmOrders) is not open, then what?

I FINALLY figured out my problem. The way I set it up was for the frmCustomer to be filled out first then active button to frmOrders and the frm(Details). You are right that in order to make it work you have to start at the beginning. It is for my son and there are only three employees and I can do this through training.

What I was doing wrong all the time was trying to ask Access to use TWO detail tables. I would get one to work but then the other wouldn't be recognized. I put all details of every order in one table. Works great. For some reason I got it in my head that they should be separated. One table was for Apparel and the other was for his trophies and plaques.

I have been assisted by many people in this forum and feel like I should THANKS all who participate here.
Thanks again for your consideration. S

[burrina]

Glad you got it sorted out. Good Luck With Your Project. We are all glad to help.