create dynamic lookups with one table and one column

PHPMaker General Discussion (PHPMaker)
1

hi allI have an address table with the structure:
AA : province
AABB : district
AABBCC : districtexample
AA : Central Java Province
AA01 : Semarang Regency
AA0101 : Matesih District
AA0102 : Sragen District
AA0103 : Wonogiri District
AA02 : Pati . Regency
AA03 : Surakarta Districthow do I make it dynamic when filling in the province of Central Java, only districts in Central Java appear, in the example there is already dynamic but uses a different column. How about all in one column?
thank you

2

i think you speaking about a basic “tree” feature (likely files/folder/subfolder/drive… featrure)

3

You need to create view(s) from your table and then use the views as lookup table for the child field(s). The data in the view should be like:

ID Province District
AA01 AA 01
AA02 AA 02
...