Display names from multiple table in lookup

PHPMaker General Discussion (PHPMaker)
1

Hi i have one foreign key in table named coupons the foreign key is names coupons_category_id which is related to coupons category.
In coupons category table i have name, project_id, country_id.

I have the lookup table in coupons the coupons_category, link field is id and display value is name and second field is project_id and third one is country_id.
Is there any way that i can display the name for project_id, country_id in list view.

In edit the select show the 3 fields with comma seperator each one with name but in list page it display the first value by it’s name and the second and third by id’s.

eg: Cinemas,1,1
i want to be like : Cinema, Grand Cine, France.

Thanks in advance

2

You may create a view to join coupons_category, project table and country table first, then use the view as lookup table.

3

It’s a great idea i never knew that i can use join as lookup table.
Thank you.