3 Replies Latest reply on Dec 16, 2014 11:58 AM by philmodjunk

    Relationship - ether - or



      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.