Hi,
I want to create a new shipment record , pulling information from a list of PO items and then adding the new record to a different table.
Each shipment will have items from several different PO's and but only some of the items from each of the PO's.
So I would create the new shipment number then find the correct PO number from the PO file, select the items off the given PO and add them to the shipment. I then need to repeat this with other PO's to add to the same shipment.
This would then be added to a new table to do other manipulations with.
Hope you can help