5 Replies Latest reply on Sep 13, 2014 5:04 PM by PSI

    Look up values starting from different fields

    simplydotca

      Let's say I have two tables, lineitems and products, and both of the following fields:

       

      sku (unique)

      manufacturer

      part_number (unique)

      description

      price

       

      lineitems::sku and products::sku have a relationship together.

       

      When I create a new record in lineitems and enter a sku, a lookup will be performed on products to fill in the other fields in the lineitems record.

       

      Can I also create a separate relationship between these two tables, that does a lookup based on matching part_number?

      This way a user can populate a lineitems record starting with either a sku or a part_number.

       

      Thanks!