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

jackm75 — Sat, 13 Mar 2010 22:42:42 GMT

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

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

jackm75 — Sat, 13 Mar 2010 23:14:55 GMT

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

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

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

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