Thanks for the response, I should clarify. We don't need to reference a field, just which table to use. For example, in our log event, we may have: Event_1, HR, Event details... Event_2, Engineering... Event_3, Finance... Our dbxlookup/query is used to add in details such as UserId in event to UserName from DB. This is just a simple query like 'select UserName from db.Engineering.Users WHERE UserId=XXX' Unfortunately, the users for each department are in different tables. For example db.Engineering db.HR db.Finance We've been forced to create individual lookups for each department/region. I'm more versed in SPL, but know enough SQL to be dangerous. Perhaps there is a way in SQL to do this through one query which I'm missing? I hope that helps clarify the question...
... View more