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)

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!

Outcomes