DropDown populate text field

[zeon]

I have a dropdown pointing to a secondary datasource in MS/SQ, that holds a
code and associated description. I want the dropdown to display the
descriptions, but when the user selects a description, I want to only store
the code in the main connection database.

I'd like to do this without code, if possible. Thanks!

 

[S.Y.M. Wong-A-Ton]

When you say "main database connection", I assume that you've bound your form
template to a database? If that is the case, just drag the field in which you
want to save the code (from the dataFields section of your main data source)
to the form template , drop it on the form, and convert it to a drop-down
list box. Then bind that drop-down list box to the secondary data source and
use the description as the "Display name" and the code as the "Value" for the
drop-down list box. Now the code should automatically be stored in the field
in the main data source when you select a description from the drop-down list
box.

 

[zeon]

Thanks that worked. What I did not realize is that if you want to be able to
change the value and display name, the Entries cannot point directly to the
column but just point it to the name of the secondary datasource; otherwise
the value and display name will be set to "." and you won't be able to change
them. Thanks again!