Let's say I have two tables, lineitems and products, and both of the following fields:
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.