To keep it short: I have a Query where I am trying to set up DLookup criteria based on the following tables and headers (simplified):
table 1: ID, topic, location, team
table 2: ID, topic, location
table 3: team, topic, location
Basically in my criteria I want to return the following:
if the ID in table 1 = the ID in table 2 return the topic from table 2; if not, but if team in table 1 = team in table 3, return the topic in table 3
I'll need to do something similar for location, but I should be able to figure it out based on the response.
Thanks in advance