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]

[Ankur Bawiskar]

@fehbqhbi1 

how core_company and core_company_id are linked?

reference variable will show only 1 table data

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[fehbqhbi1]

so that core_comapny is OOB table but core_company_id table is extend from core_company table,
so the field are 
1.Company name type reference 
2. Company id variable type string

[Ankur Bawiskar]

@fehbqhbi1 

but core_company_id extends from core_company then why not make your variable refer to this new table?

what's your actual business requirement here?

[fehbqhbi1]

i want to show the choice like core comapny and their id in the catalog variable like below
Core_company_1 - core_company_id_1
Core_company_2 - core_company_id_2