Display Multiple Columns in a Dropdown List

The foreign key can be displayed as a combination of different columns by adding the columns with a separator in the Display As section.

Step 1:  In the Layout Editor, select a dropdown list control and open the Property Sheet.

Step 2:  In the Control section, Actions group, select the ‘Populate from Database’ event.

Step 3:  In the Actions dialog, enter a formula that combines several fields, e.g.:

= LastName + “,” + FirstName


Step 4:  Build and run your application.

Note: Reference to CustomerId in another table will not be changed to the two columns unless you apply the customization for that table as well.

See Also

Common Formula Examples