Jump to content

Duplicating records to a new DB


FSRGuy27

This topic is 8220 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 8220 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.