Show Users in object

[adamatio]

Hi guys,
I want congreats with you for very good job with nuBuilder project,
I need your help about one things that don't work.
My aim was that one user log with his credential and when go to add new record appear one object that permit to save in record also his userid.
My first try was create a display object with this SQL code:
SELECT ID_UTENTE FROM tb_utente WHERE tb_utente.N_UTENTE='#zzsys_user_id#'
and incredible work for globeadmin but this code don't work with all other user, I have try all but don't work.
Please have you some suggest for solve this little problem.
Thanks
Regards
Andrea

[admin]

Andrea,

Try this..

def.png (33.56 KiB) Viewed 2982 times

Hope it makes sense.

Steven

[adamatio]

Thank you so much for help, probabilly I haven't understand perfect your suggestion because I don't be practice with lookup object but you help me to find a solution.
I have solved in this way:
I have see that if you select '#zzsys_user_id#' you see a alfanumerical code that automatically identifiy the user when created;
so if you modify by phpmyadmin the record zzsys_user_id directly in table zzsys_user and put the same text present in sus_login_name you have much of zzsys_user_id with name of users.
After this I have used a display object with this SQL code:
SELECT N_UTENTE FROM tb_utente WHERE N_UTENTE='#zzsys_user_id#'
making a match with another table with users and other characteristch.
I hope to help someone.
Thanks for help.
Regards
Andrea

[admin]

.