I'm storing the current user in the table "ao_teilnehmer" in the field "tei_userid". The records of this table shall be displayed in the sub_form. In order to display the users which have saved the records by nameinstead of the user_id I've introduce a DISPLAY field with the SQL statement:
SELECT sus_name
FROM zzzsys_user
WHERE zzzsys_user_id = '#tei_userid#'
The issue is, that this SQL statement is always empty as '#tei_userid#' is not substituted with the database entries.
What's wrong with this approach?
Welcome to the nuBuilder Forums!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
DISPLAY sas_name instead of zzzsys_user_id
-
Tom_24409
- Posts: 4
- Joined: Sat Aug 15, 2015 3:16 pm
Re: DISPLAY sas_name instead of zzzsys_user_id
changed the form; storing now the user-name directly instead of the ID.
Re: DISPLAY sas_name instead of zzzsys_user_id
Tom,
You could also try using a lookup with the readonly Description field showing the name.
Steven
You could also try using a lookup with the readonly Description field showing the name.
Steven