Custom dropdown lists

The userID that is stored in the session is the name that user entered into the login screen
If you need the numeric ID, you could query the DB and place the ID in another session
and put the code in the after login successful event

Hi Kujox,

Thanks for steering me in the right direction.
For use by others this is what made it work.... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=10109&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />
In the "After Successful Login" event insert the following customer code:
// put your custom code here

global $conn;

$rs = db_query("select userid from users where username='".$_SESSION["UserID"]

."'", $conn);

$data = db_fetch_numarray($rs);

$thisusersID = $data[0];

$_SESSION["usersIDnumber"] = $thisusersID;

}
In this case userid is a bigint field in the users table that contains the numeric identity of this user.
In the WHERE section of the lookup table wizard insert the following:
"userID=".$_SESSION["usersIDnumber"]
In this case userID is a bigint field in the clients table that identifies the user responsible for this client.
Works just the way I need it to work only showing the client for the user who is signed in...
Amazing what we can do with phprunner even with practically no knowledge of php.
Giles