We have a set of 20 carts (ID=10, 11, ..., 30) that move orders. After processing, a photo is made of the cart and we want to relate the photo to the order number of the product that is on the cart. So a one (order) to many (photos) relationship.
First, the cart and the order number are scanned and we have a table with that information including the time of the numbers being scanned. However, when the photo is being made the cart is scanned again but no information about the ordernumber is given. From this we have a table with the cartnumber, photonumber and time of scanning. Because the carts are being reused over and over their numbers are not unique. We were wondering if a relationship can be made using the time steps of scanning.
How can we relate the ordernumber to the photo?
Scott Axton
@Reply 4 years ago
In my mind you are scanning the wrong thing for tracking.
I think you should be using the Order Number for all tracking - NOT the Cart Number.
#1. - The cart is just a tool, used to facilitate movement, of your order through the process. What happens if the Cart 3 breaks down and you have to place the order on Cart 5 to complete the process?
You don't want to have to redo all the records previous to changing carts.
#2. The information you are tracking belongs to the order. NOT the cart. You are concerned with did order A101 - go through Step 1, Step 2, Step 3? Who cares what cart was used to transport which order?
Kevin Yip
@Reply 4 years ago
I'm with Scott. You need to put order number in your scanning process, and/or any number that identifies the order. Are these goods being packed for shipments? If so, you may use shipment tracking #s in your process. That's how we did it in my old job. Each tracking # can identify which order it is, what content is in the box, what destination it is sent to, etc.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
