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.