I have imported certain tables into Access 2010, and am building queries to do reporting.  The current query I am trying to create is; what mapped drives does each user have.

I have the Invmappedlogicaldisk table with 2 unique fields:  USER_NAME & COMPONENT_ID

What relationship can I link one of these fields to in order to correlate it with a valid user in the aduser table?  If it needs to link to a computer and not a user, what is the relationship and to what other tables?

Thanks.