AnsweredAssumed Answered

Look up values starting from different fields

Question asked by simplydotca on Sep 12, 2014
Latest reply on Sep 13, 2014 by PSI

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.