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?

[Tanushree Maiti]

Hi @fehbqhbi1 

• Navigate to your Service Catalog Item 
• Open the specific Reference Variable.

• Ensure the Reference field is set to core_company
• Update Variable Attributes

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=core_company_id,ref_ac_columns_search=true,ref_ac_display_value=true

Note: Assuming  core_company_id is field of Core_company