In Italy we have this territorial division:
State ----- Regions ------ Provinces ------ Municipalities (Comuni)
1 State = Italy
20 regions = Campania, Lazio brands etc..
110 provinces = Rome, Milan, Naples, etc..
8100 Comuni = Latina, Foligno, Narni etc..
so for example we will have:
Italy
(Region) Umbria -> (Province) Perugia and Terni
(Provincia) Perugia -> (Comuni) Marsciano, Todi, Umbertide, Citta 'di Castello, Foligno eTc..
(Provincia) Terni -> (Comuni) Orvieto, Narni, Amelia, etc..
In OSclass The database includes only:
State
Region
City (Province)
You can add or modify a table to relate the municipalities (Comuni) with the provinces (current City), so every as it is now for Regions Cities?
thanks