Relationship - ether - or
I have two tables:
When I enter items into inventory, If I have that item in the Item Master, I want it to fill in the fields. normally that's not an issue but there is a twist.
When entering an item, i may have an OEM Part number or it can be a Manufacturing Part Number, ether or usually not both.
Both the inventory table and the Item Master tables have the two fields
OEMpart < OEM part number
MFGpart < manufacturing part number
HOW can I set the relationship so it looks at ether one of these to complete the relationship so I can fill in the data in the associated fields.