Hi
We have a database that tells our offsite warehouse what the contents are of each load. Among other info, is the order number and the number of pallets.
When the load reaches the warehouse, they will then book the pallets in. Firstly confirming the full load has been received, then booking in individual pallets by entering the rack and location they have been moved to.
What I need assistance of is to split out the number of pallets entered at loading bay so that the offsite warehouse can then book in individual pallets:
So at loading bay they will for example say order number ABC 4 Pallets, Order Number DEF 2 Pallets and enter trailer number XYZ
When the offsite warehouse receive this they will click on a button to receive this load (entering trailer number and date will bring up the full load list), which will then write to a table (Table_Example for now) and create 4 individual rows for order number ABC and 2 rows for order DEF.
I am comfortable creating the buttons and updating the required info into Table_Example, but just need assistance on the code that looks at the total pallets for each order then splits this into individual rows.
Thank you in advance for your time and effort.