How to display different column values on reference fields on a form?

[Sai_Dilip]

So, I have 3 fields on a catalog referenced to "cmn_location" as follows:

1. City

2. State

3. Country

Currently the "Name" field on the "cmn_location" table has the Display Value set as "True", but I need to show City, State & Country on the respective fields. Any possible method for this?

[Ankur Bawiskar]

@Sai_Dilip 

you will require 3 different lookup select box variable referring to "cmn_location" table

In each of those have Lookup label as City, State, Country respectively

If my response helped please mark it correct and close the thread so that it benefits future readers.

[mayankkumar]

Hi @Sai_Dilip,
Go with the LookUp select box approach as @ Anand2799 , @Ankur Bawiskar suggested
-----------------------------------------------------------------------------------------------------------------------------------------
Please mark my response helpful and accept as solution
Thanks & Regards
Mayank