Hello,

I have a list of value that looks like this:

select LOGIN as display_name, APEX_USER_ID as return_value

from TBL_APEX_USER

where enable=1

order by login

Then for one Select List item, I use this list of values as the source.  The question is after a while, some user will be marked as disabled in the database.  Then their name won't show in the Select List item, instead, the user ID is displayed.  I wonder how I can still display the name of old users, but in the dropdown list, I don't want them to be listed. Say, for this Select list, it's used for both adding/updating new user and displaying existing value correctly.

Thanks.