Hello,

I need to create two extra fields, one for regions and one for subregions like states and cities.
First field is ad_regions (drop down single select)
Second field is ad_subregions (cascade child field)

There is two options I can use to enter region names , subregion names , values and parent values.
The first option "data stored in AdsManager" is very easy to understand.
But I am looking for the other option "data stored in external table", because I have to enter about 21 regions and more than 300 subregions.

To do this I know I have to create a table with columns in the database and enter data there by creating rows.
But could you please explain me how many tables I need to create.
Is it two tables ( one for regions with two columns and another one for subregions with three columns),
or do I need to create one table with three columns (a column for regions, a column for region value and a column for subregions)

Best Regards.

I think I have understood.
Regions table two columns (ID colum and Regions_name column)
Subregions table three colums (ID colum , Subregions_name colum and Subregions_id colum),
and I have to link the the ID of regions table to the subregions table by implementing foreign key.
Am I right?

I have created mysql tables and inserted data, and after filling required fields in "data store in external table" correctly, it works perfectly. Thank you so much for the help.
But I have small issue. The field details are not showing correct order in add mode (detail view)

Now it is showing like this.
Seller:
Subregion:
Phone:
Region:

How can I reorder fields like this on detail view.
Seller:
Phone:
Region:
Subregion:

Best Regards.