AnsweredAssumed Answered

Retrieve Field Data from Specific Record

Question asked by ToddBest on Jan 30, 2015
Latest reply on Jan 30, 2015 by philmodjunk


Retrieve Field Data from Specific Record


I am creating a Systems Table that is made of multiple products from a Products Table. Easy enough, I made a Systems Detail Table where the users can add the items that make up the system. The Systems are a construction products that are made of layers of different materials. My headache is this; There are some products that are upgrades to certain layers in the System that are universal for all systems, for example:
-  All Systems have to have at least 1" foam (this is stored in the Systems Detail Table)
-  The foam can be upgraded to 2", 3", etc.

So I am wanting to get the price of  2", 3" etc. Foam and show that price on the System Layout. The price of foam changes often so I need to keep the price updated. So how do I get the price for the Foam from the Products Table when the relationship is already built for the Systems Detail Table? 

I do apologize, I'm even having a tough time explaining this..