AnsweredAssumed Answered

Bind multiple fields to one field in another table

Question asked by StephenHudson on Jul 24, 2015
Latest reply on Jul 24, 2015 by philmodjunk

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.

Outcomes