Ok, i wasn't sure how to sum this up in the title or even search this because i'm not sure what it would be called in VB or Access.

What I have is a db with transactions done by about 5 or 6 users. Each user has their own user name and instead of displaying the user name i'd like to link it to another table that has their full name attached to their user name. (i.e. jsmith --> John Smith) and i would like to make a drop down box for a search/filter so that in this drop down box it pulls the full name instead of the user name.

thanks in advance for any help.