HI Dave
The issue here is not with Look up i am thinking.
The look up working correctly as we need that lookup to show only the logged in user details(FN, LN, Email etc.) to select.
The field which is using this lookup, is showing the name of the logged in user as the value only when i select my name of that look up when i was logged in. Please suggest.
PFB the nsql query.
SELECT @SELECT:u.id:user_id@,
@SELECT:u.USER_NAME:UNIQUE_CODE@,
@SELECT:r.id:resource_id@,
@SELECT:r.first_name:first_name@,
@SELECT:r.last_name:last_name@,
@SELECT:r.full_name:full_name@,
@SELECT:r.person_type:person_type_id@
FROM srm_resources r,
cmn_sec_users u
WHERE u.id = r.user_id
AND u.id=@WHERE:PARAM:user_id@