M
meangene
Want to populate a table with fields Receipt_No, PO_No, Item, Qty_Rcvd,
Rcv_Date Where the Receipt_No will change to the next +1 value if the PO_No
changes. Receipt_No for first record will come from PO0.NextReceiptNo.
Example:
Receipt_No PO_No Item Qty_Rcvd Rcv_Date
00056 A1234 123B 2 8/22/2008
00056 A1234 321C 4 8/22/2008
00057 B9876 667G 10 8/22/2008
How would best way be to do this? Thanks!
Rcv_Date Where the Receipt_No will change to the next +1 value if the PO_No
changes. Receipt_No for first record will come from PO0.NextReceiptNo.
Example:
Receipt_No PO_No Item Qty_Rcvd Rcv_Date
00056 A1234 123B 2 8/22/2008
00056 A1234 321C 4 8/22/2008
00057 B9876 667G 10 8/22/2008
How would best way be to do this? Thanks!