Bind multiple fields to one field in another table
I have an "Asset" table with 5 fields
and I have a Software table with a value
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.