Customize Modal Lookup

PHPMaker General Discussion (PHPMaker)
1

Hi
I have 4 table about location
1.Province
2.Regency
3.District
4.Village

Field in province table
1.ProvinceId (INT)
2.ProvinceName (VARCHAR)

Field in regency table
1.ProvinceId (INT)
2.RegencyId (INT)
3.RegencyName (VARCHAR)

Field in district table
1.ProvinceId (INT)
2.RegencyId (INT)
3.DistrictId (INT)
4.DistrictName (VARCHAR)

Field in district table
1.ProvinceId (INT)
2.RegencyId (INT)
3.DistrictId (INT)
4.VillageId (INT)
4.VillageName (VARCHAR)

As show in dynamic selection help file, when i use modal lookup in village field only show :
VillageName, ProvinceId, RegencyId, DistricId

How to make modal lookup like this :
ProvinceName, RegencyName. DistrictName. VillageName…

Thank you for your help.

2

You may create a view to join the tables first and then use the view as lookup table.

3

Thank you its work