Ok I am building my Product Entry Form in Access. I have several tables I would like to place on a single main form. The Tables involved are
The Main Form is built on the SKUs Table.
Skus, Products, and ProductImages Tables all have the SkuID field in common.
ProdLocations does not have the field SKUid in common.
Products and ProdLocations Tables do have the field ProdLocID in common
The SKUs table is the items being sold but they are not a PRODUCT until we review them and give them a Product Condition and then that PRODUCT is stored in the Products Table.
Once we make the PRODUCT we then have to Inventory the product in the ProdLocations table.
I would like a all in one form so that the user can input all the info and then in the ProdLocations Table put the Total amount in the RECEIVING AREA LOCATION in the ProdLocations.
The Receiving Area Location is just that Receiving and after that we can send it wherever. But we need to know how many Products we have in the Reviving area awaitng to be put away elsewhere.
So I need to link the ProdLocations Sub Form and the Main SKUs Form together.