Show 2 table data in 1 catalog item variable.

[fehbqhbi1]

I have a requirement for one of the catalog item variable where variable type is refecne field and its refer to core_company table and now i want to show case the company id which is related table of core_copany table named assumed core_company_id so the select option/dropdown should look like core_company [core_company_id]

[fehbqhbi1]

these are 2 tables actually so i want to combine the field and showcase in one catalog item variable like this
company_name[company_id]

[Aditya_hublikar]

Hello @fehbqhbi1 ,

Even you created database view for this requirement , in display value you will get only 1 field not concatenated one .(database view as reference table will work only for catalog variable not normal table field)

[fehbqhbi1]

i guess this works for me can you please share the step to re porduce same