I have a database (Access 2013) where I store modifications done to engineering parts. I have 10 fields each with the same lookup so that users can select multiple parts the modification has been applied to.
ModID: MODIFICATION-001 (Primary Key)
PartAppliedTo2: Example 2
PartAppliedTo4: Example 4
PartAppliedTo5: Example 5
I need to be able to query all of these fields (PartAppliedTo1-10) with a part name and return a list of modifications that have been done to this part.
It works if I only apply the criteria to one of these 'PartAppliedTo' fields but multiple fields just returns no value.