Help with getting correct values for a List Box. ~ New User

[jackm75]

My objective is to get only the User's first names (FName) who appear in the UserAssigned field to display in my List Box. This set up returns ALL user names in the list box, not just the three that are UserAssigned. I have no problem just getting the desired UserAssigned numeric values to show... I just can't get the names. I've tried everything I can think of... HELP!

Users:
ODBC CONNECT TO <MS Access Database>;
SQL SELECT FName,
NameID
From tblUsers;

AgencyInfo:
ODBC CONNECT TO <MS Access Database>;
SQL SELECT AgencyAddress,
AgencyCity,
AgencyID,
AgencyMainPhone,
AgencyName,
AgencyState,
AgencyStatus,
AgencyZip,
UserAssigned as NameID,
Website
FROM AgencyList;

UserNames:
Load Distinct NameID,
FName
Resident Users;
Outer Join
Load NameID
Resident AgencyInfo;

Thanks,

Jack

[jackm75]

I figured it out.... Not sure how to delete the post...