
Announcements
I have a form (tbl_Incidents) with a data card with employees. The table that it is pulling from has a lookup value to the employees table.
I am trying to add a row in tbl_Incidents which has a lookup column pointing to tbl_Employees. When I create the edit form, the primary key from tbl_Employees shows up and I can change it to one other column (first_name). I want to have it display "first_name, last_name".
I tried Concatenate(["cr4ac_first_name"],", ",["cr4ac_last_name"]) in the DisplayFields but it just shows blank rows.
Thanks for the help!
Hi @JoshBog
Another option is to change the Layout of the combo box from Single to Double and display First Name and Last name.
Example
Now your DisplayFields of the combo box should be
["cr4ac_first_name","cr4ac_last_name"]
Thanks,
Stalin - Learn To Illuminate