I successfully implemented the related comboboxes as in your example with region/country/state/city/... where my data was in separate tables - one for each level. The design of the database has changed, and the geographic data is now all in one table with a 2 id fields - one for the data and one for the parent making it a self referencing table, and the highest level has the parent as 0. So for example, Africa has a tid=22649 and parent=0 and then one of it's children is Eastern Africa with a tid=22661 and parent=22649.
There is not a set number of levels for any parent.
Are there any examples of how I can implement this new table layout in a related combobox?
Thanks,
Laura
There is not a set number of levels for any parent.
Are there any examples of how I can implement this new table layout in a related combobox?
Thanks,
Laura