Hello
I am creating a canvas app and have created a lookup column in my employee details table as company code. This column is related to table companycode mastertable which have columns company name as primary column, company code and country.
When I am in the employee details table and using the company code column it is reflecting values of Primary column which is
company name whereas I want to see the company code values. when working through app it is showing correct values but in table it is not.
Attached is the image where company name and company code is showing same value.
Hi @oshinjain
If you want to see the Company Code in the View of the Employees you can definitely do this. When adding fields to your view of Employees you can click on the "Related" and this should show your Company Code table since this is a related table from your lookup. From here you can add the Company Code to your view...
Hello Drew
So you mean I will not be able to see the actual company codes in the company code field in this view.
Hi @oshinjain
Lookup columns always refer to the Primary Name column in your related table. You can add (in your view) the company code to the view if needed (choosing related and adding the column when building the view). You can also setup the Lookup view of your CompanyCode table to show the CompanyCode first and then the Primary Name field if you want as when you are populating the lookup it will display the CompanyCode first and then the Primary Name field. Note, once you select it will display the Primary Name field though in the Lookup column...