Duplicating records to a new DB

[FSRGuy27]

I have two files, OrderEntry and Receiving. Each record in OrderEntry corresponds to one PO number. OrderEntry also has a portal linked to a file called OrderPartJoin that lets me input multiple discrete parts per order, along with the corresponding information for each part.

Problem: I want to be able to duplicate each record (along with all of the parts in the portal) from OrderEntry in Receiving, so that I have one order per record. The trick is that we often receive parts from an order in multiple shipments (if we ordered 1000, we might receive 200 in a shipment, then 400, then 300, then 100 to finish the order). I need to be able to track the number received for each part so that I know where we stand at any time on an order, along with the dates for each shipment received. There shouldn't be more than 5 shipments on any single order, so I think I can use a repeating field and put it next to a repeating date field, but I don't know how to separate the parts or link them to the receiving quantities and dates.

Any input would be greatly appreciated.

-A Confused Newbie

[tlsparker]

Rather than using a repeating field, would it make sense in the context of your application to create another portal in OrderEntry that looks into Receiving? You could enter received shipments via the portal, the shipments would automatically be tied to the order, and you would be able to keep only one record per order in the OrderEntry file.

Hope I understood you correctly...

Tom