AnsweredAssumed Answered

Relationship - ether - or

Question asked by dansan500 on Dec 16, 2014
Latest reply on Dec 16, 2014 by philmodjunk


Relationship - ether - or


I have two tables:

(1) Item_Master

(2) inventory

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.