Do you know the "real names" as a whole, or are you trying to determine what the "real name" is depending on user ID? The easiest way is create a sub-table with 3 fields: USER_ID, LNAME, FNAME.Originally Posted by MWE
There is no one answer to your question. I have wanted the user's "real" name on a number of different applications and a unique name (or something) on others. I fiddled with various approaches and often used email address as the one unique identifier. Back before ol was security nuts, and since most users run single profiles, fetching an email address was pretty easy.. It is now more a matter of personal curiosity and that funny drive to finally find a way.
Then use the table as a matrix to display whichever name you wish to see. You can also concatenate the LNAME and FNAME if you want them to appear in a single cell on return.
Reply With Quote