Need Advice: Assigning a Packing Slip number to Multiple Records (1 Viewer)

hbrehmer

Member
Local time
Today, 04:11
Joined
Jan 10, 2020
Messages
78
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?

1588256739223.png
 

Ranman256

Well-known member
Local time
Today, 07:11
Joined
Apr 9, 2015
Messages
4,337
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

Member
Local time
Today, 04:11
Joined
Jan 10, 2020
Messages
78
Do you have an example? I've never used list boxes.
 

Ranman256

Well-known member
Local time
Today, 07:11
Joined
Apr 9, 2015
Messages
4,337
example attched
 

Attachments

  • Listbox picklist.zip
    811.4 KB · Views: 93

Users who are viewing this thread

Top Bottom