3 Replies Latest reply on Jul 24, 2015 2:17 PM by philmodjunk

    Bind multiple fields to one field in another table

    StephenHudson

      Title

      Bind multiple fields to one field in another table

      Post

      I have an "Asset" table with 5 fields

      Key1,Key2,Key3,Key4,Key5

      and I have a Software table with a value

      Key

      Now if Key1-5 in the Asset table I want it to relate it to the software table that matches Key

      I can do a simple Key1 = Key binding on the table but if I try to do multiples where it try's to make sure Key1 AND Key2 match the Key in the Software table where what I really want is it check for Key1 OR Key2 but it won't let me change the AND to a OR.