Order Receive Form Detail

[aron.ridgway]

Hi There i need some pointers as im struggling with a form setup,

I have a Purchase Order system with an OrderDetail and Order Table.

I have created an ReceiveDetail and Receive Table.

i need to receive the order, i currently have a main form with a subform.

Im struggling with the subform, i need to display the orderdetail, calculate the qty outstanding and a text box that you can add a receive detail qty that will create a new record in the receiveDetail table?

any pointers would be great as im going round in circles.

 

[burrina]

If the 2 subforms are linked correctly then there should be no problem.
Maybe further explanation is needed. Normally OrderID