I have 3 tables that keep Province Name, District Name and Hood Name. On my form there are field related to table's fields. Here is my question:
- First, i will select Province Name
- Second, i will select District Name depending on Province Name
- Third, i will select Hood Name depending on District Name
For example, NY > Long Island > Garden City. Refer to the attachment (SS) if necessary.
A relationship should be set between tables and some configuration should be made when binding data to the related field, but I'm a newbie and still learning, need your help.
Any help is appreciated.