This topic is locked

Displaying values from other tables on List or view pages

2/29/2016 8:21:30 PM
PHPRunner General questions
B
Bowman author

Is it possible to display a value from another table (related) on the list or view page?

I have 2 tables related by cCode(company code) field - Service(detail) and Company(master). When displaying the service record in a list or view page, I would like to display the company name from the company table in place of the cCode field from the service table.
Any insight would be appreciated.

jadachDevClub member 3/1/2016

You can join tables in the SQL editor, then display any field you want on the list page.