nuBuilder Forum

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?

changed the form; storing now the user-name directly instead of the ID.

Tom,

You could also try using a lookup with the readonly Description field showing the name.

Steven