Although my question is answered and resolved (as suggested by
@June7 in post # 2) but just for information and out of curiosity, can you explain a bit more because I dont about flags and how to put flag in table.
A 'flag' is just a term to signify something? It just flags up how a particular set of data should be processed.?
You could have a field with Y or N in it called ShowUser and then only select those records that have a Y in that field. It could be boolean?
It is just some method to identify records for a partcicular process.
The benefit would be, if you decide another user should not be shown, you at the moment have to amend code.
If you put the choice into a table then no code needs to be amended when the requirement is?
As you already have a table for users, it would just be another field.
HTH