Thanks in advance for ANY help.
I’m in the process of writing an Inventory Control Program. I have everything written except a form that will create the shipping manifest. This form-subform will get its information from several different tables and or queries.
As of Now:
The Form/Subform builds the shipping manifest data. The Table: tblShippingMaster is the table that will hold all of the items that will be shipped from my location.
Mainform: frmShipping1
SubForm: frmSubShippingMaster
On the main form the user will enter the usual shipping stuff; Ship to location, what shipping company for this order, shipping clerk and shipping date.
The subform part will ‘build’ the items that will ship, and store all of the above data plus the items that are shipped.
The subform; frmSubShippingMaster, has four fields that the user will see. The first field needs to be a combo box that looks-up data from a TABLE; tblCatalogModelNumber but writes the Catalog Model Number and the Model Description to TABLE; tblShippingMaster. Also another field in the subform will need to look-up available work order numbers that the current catalog model number will use to ship against.
For example: One record in frmSubShippingMaster, table; tblShipppingMaster will have a catalog model number, model description, amount shipped, work order number for that order (based on catalog model number) , and data from the main form; date, shipping clerk, unique identifier number, ship location and ship via information.
The trouble that I am having is how to write the code to look up data in one table and write that data into another table.
Thanks for any help.