troubleshooting Question

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

Avatar of Dustin Stanley
Dustin Stanley asked on
Microsoft Access
26 Comments2 Solutions502 ViewsLast Modified:
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!

Join our community to see this answer!
Unlock 2 Answers and 26 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 26 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros