AnsweredAssumed Answered

Look up sub product

Question asked by MikeWile on May 4, 2015
Latest reply on May 5, 2015 by MichaelWile


Look up sub product


I have a TO that has a Product ID. In this table there is be a field for Type and a field for price. For instance I can have Product ID = socks and a type = Red Sox, and a price of $1.

The type "Red Sox" can also occur as the main product ID.

Is there a way to show socks, but have the price looked up by finding the Type in the Product ID? I know it sounds like a round about way, but the way these records were originally set up forces me to try and find a solution. There are over 250,000 records in this file.