Need Advice: Assigning a Packing Slip number to Multiple Records

[hbrehmer]

Hi All,
I am looking for some advice on how to handle this: I have to create a packing slip to ship to a vendor for outsourced services. I need to add multiple records (Parts) to that packing slip. I have a table called TktProcess that tracks each part that is in production and what process it is at. I need to have my end user select those Parts in TKTProcess and add them to a packing slip, which I have a table called VendorShip that auto assigns the packing slip number and all the shipping details required on the packing slip. I want to be able to track my part's process and which packing slip number it was shipped on. Does anyone have a program that does this? Keep in mind that I need to receive those parts back to either ship to the customer or on to another vendor. How do you think I should handle this type of entry?

 

[Ranman256]

we use a listbox.
the user dbl-clicks the item to add , it runs an update (or append) query to post the ItemID to the Packing list record.

 

[hbrehmer]

Do you have an example? I've never used list boxes.

 

[Ranman256]

example attched