How to disply field value based on Input text

[david_ze]

Hi all,

I'll appreciate your help on a issue I have:

I'm using input box to let the user enter the project number. Input field is USER_PROJECT.

After entering the project number into  the field USER_PROJECT I would like to presend into a text object the project name (field "PROJ_DES").

Fields I'm loading from the DB are Project_Number and PROJ_DES. The PROJ_DES that should be presented into to text object should be

the PROJ_DES when Project_Number=USER_PROJECT.

I'll appreciate your promptly help on how to this.

best

David

[swuehl · Accepted solution]

Try

=only({<Project_Number = {'$(USER_PROJECT)'}>} PROJ_DES)

[david_ze]

Thanks !  Workd ok...