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.