3 Replies Latest reply on May 5, 2015 3:10 AM by MichaelWile

    Look up sub product

    MikeWile

      Title

      Look up sub product

      Post

      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.