Form Help

[tl mike]

I need some help!!!

I have a form Invoice with a Sub form Invoice Details master child fields are InvoiceID. The invoice form is linked to another for Orders by OrderID and in the Orders from it also has a sub form Order Details master child fields are OrderID.

What I need to do is have the invoice details sub form show the products from the Order details. At the same time saving the products on the Invoice table.

 

[tl mike]

Actually I do want to do each record one at a time becuase for some orders I dont have enough on hand and will have to do a production run. So say today I get an order for a computer and a monitor and the customer is ok with back orders and I only have 1 computer on hand and no monitors I will be able to ship and invoice that one computer today and then when our shipment arrives two weeks later of monitors I can ship and invoice the monitor.

Which that is my problem getting the order details (what products the customer ordered) to the invoice details (to which I can show what we shipped on that invoice and what still needs to be shipped).