I have a form that I am trying to use to update a table and print an invoice. The information to update table(inventory) is to come from 2 other tables (customers & Shippers). There are 6 fields on the form they are 1
roduct, 2:Trailer #, 3:Customer, 4:Invoice #, 5;Driver Name, 6;Delivery Date. There are 3 different Products. Each product may have many different Trailer #'s. I would like to use the product to pull in the other information and update the table Inventory and print the invoice.
The information from the table Inventory is 1;Product 2;Trailer # 3;Location in lot of Trailer.
The information from the table Customers 1;Customer 2;Facility 3;Address.
The information from the table Shippers 1;Company 2;Truck # 3;Driver Name 4;Cell #
I need advice on how to do this! Please HELP!!!! Thanks
roduct, 2:Trailer #, 3:Customer, 4:Invoice #, 5;Driver Name, 6;Delivery Date. There are 3 different Products. Each product may have many different Trailer #'s. I would like to use the product to pull in the other information and update the table Inventory and print the invoice. The information from the table Inventory is 1;Product 2;Trailer # 3;Location in lot of Trailer.
The information from the table Customers 1;Customer 2;Facility 3;Address.
The information from the table Shippers 1;Company 2;Truck # 3;Driver Name 4;Cell #
I need advice on how to do this! Please HELP!!!! Thanks
Last edited: