We help IT Professionals succeed at work.
Get Started

MS Access Form Building With SubForm Sub-SubForm Linking Without Similar ID Fields

Dustin Stanley
Last Modified: 2016-09-30
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.

Thank You!

Watch Question
Distinguished Expert 2017
This problem has been solved!
Unlock 2 Answers and 26 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE