Products

Purchase Order

Purchased Products

Sales Orders

The Purchase Order form has the "Purchased Products" as a subform. The "Purchased Products" form has lookup field from Products. So the user loads the form Purchase Order, clicks on Add New "Purchase Products", selects the product and add the purchasing price and quantity. Then other fields as Subtotal and Total are updated on the form "Purchase Order".

So far so good.

Now, my problem is on the Sales Orders form. There I have a lookup field to select the Purchase Order number from which the sales will be generated from. And the Purchased Products is also a subform here. What I want is that when I select the Purchase Order number in this lookup field, the subform SHOWS the records from the Purchased Products form that related to this Purchase Order number. So that the user can update the sales prices and quantity and generate this order.

I dont know if I am totally clear but basically how do I make a subform show multiple records (in the form view, not report) that were already added according to an action in the mainform.

Thanks a million to whoever helps me solving this puzzle!