Write back query order to table

[benkingery]

I have a query that is used to generate some shipping labels. The order that those labels are generated matters a great deal because we use those shipping labels to go through our warehouse in an orderly fashion and pull what is on the list to be pulled. The data in the query is exported and then used to integrate with some shipping software via a .csv file. This query is based off of a Shipping table.

What I want to do is take the exact order that the records export and write a numerical value back to another table to tell it what order the items were exported in. This is important because I then have to print packing slips based off of an Order_header and Order_lines tables, which are related to the shipping table.

My end goal is the print packing slips in the same exact order as I export the shipping labels. So, if the exported query exports the records in this order:
Primary Key Order Exported 555666 1 666777 2 111222 3 222333 4 444222 5 111555 6
THen I want to write back the data to the Order_Header table (where there is a 1 to 1 match with the records in the Shipping table, so that the data would like this on the Order_header record:


Primary Key Order Exported 111222 3 111555 6 222333 4 444222 5 555666 1 666777 2

Anyone have any ideas on how to do this?

 

[benkingery]

Dang it. My charts didn't post properly. THey were supposed to look like this.


OrderNumber OrderExported
___________ _____________
555666 1
666777 2
111222 3
222333 4
444222 5
111555 6

OrderNumber OrderExported
___________ _____________
111222 3
111555 6
222333 4
444222 5
555666 1
666777 2

 

[benkingery]

Anyone out there care to take a stab at this one?

 

[highandwild]

So... Each label is for an item on a shelf and there is only one item on each order then why do you have two tables when it is a one to one relationship.

Can the query from the shipping table just be linked to the orders table or vice versa?

Tell me more....