I have created a sub report that I would like to check and return matches against two fields in the main report.
Item1 and Item2 are columns on the same table, while item3 is a field on another table that can match both item1 and item2.
When building the relationships in the GUI the properties turn out like this.
Link Master Fields: item1;item2
Link Child Fields: item3;item3
But there are no results.
Link Master Fields: item1
Link Child Fields: item
I get the matches for item1. If I change item1 to item2 that works also.
I assume this is because access is treating the relationship as an and instead of an or. Is there a way to get both?