Sub-SQL Query off of formula field. Lookup user ID and get full name.
I have a report that summarizes logon attempts by users. The report parses our full text strings to get the user ID, date, and system logged on. We want to eliminate the user IDs from the report which are a formula field in the report. We want to do a sub-query of the user's ID in another table to get the user's full name. How can I create a formula or SQL field that can take the formula field @UserID and use it in a query of our full user table which is not part of the main report but added as a second table in Database Expert?