Hi all,

I am very new with access 2007, i have been trying to get data(s) from another table to be included in my subform. I didn't get any success in doing it. I hope there is somebody that can help me. Thanks a lot in advance.

Here's my table
- tblSalesOrder (ID, SalesOrderDate)
- tblDetailSalesOrder (SalesOrderID, ProductID, Quantity, Price)
- tblProduction (ID, ProductionDate, SalesOrderID)
- tblDetailProduction (ProductionID, ProductID, Quantity)

I have a production planning form from the production table with a subfrom from detail production table. What i would like to be able to do is when i input the SalesOrderID on the form, the productID on the subform be populated by the ProductID from the DetailSalesOrder table with the same SalesOrderID. So the user only have to key in the quantity that want to be produced.



One more thing is that i want the result of that input be stored in tblDetailProduction.

I hope i don't confuse anyone here. Thank you very much.