I have a student database with and a separate Financial Database. I have a relationship established between the two with lookup fields in the Financial Database. If I add another pair of fields to the relationship, it automatically defaults to AND. My question is can that be changed to OR, in other words, can the lookups be based on whether either of two fields match?
Thanks in advance!