You can do this without any extra tables if you use script and may well obtain a better solution if the States and Territories do not change frequently (they don't).
I assume your Territories are not political subdivisions but rather groupings assigned by marketing/sales. Would you mind posting your 4 subdivisions for the 31 states for Mexico?
(1) Chihuahua
(2) Sonora
(3) Coahuila
(4) Durango
(5) Oaxaca
(6) Tamaulipas
(7) Jalisco
(8) Zacatecas
(9) Baja California Sur
(10) Chiapas
(11) Veracruz
(12) Baja California
(13) Nuevo Le�n
(14) Guerrero
(15) San Luis Potos�
(16) Michoac�n
(17) Campeche
(18) Sinaloa
(19) Quintana Roo
(20) Yucat�n
(21) Puebla
(22) Guanajuato
(23) Nayarit
(24) Tabasco
(25) M�xico
(26) Hidalgo
(27) Quer�taro
(28) Colima
(29) Aguascalientes
(30) Morelos
(31) Tlaxcala
