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

    Look up values starting from different fields


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


      sku (unique)


      part_number (unique)




      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.