SELECT k_xref, municipality, old_cfsa, new_cfsa From MB_xRef ORDER BY municipality asc

Find your Regional Authority

Use the lookup below to find the Regional Authority details for your Municipality.

My nearest Municipality is:

SELECT MB_xRef.k_xref, MB_xRef.municipality, MB_xRef.old_cfsa, region.name as old_name, MB_xRef.new_cfsa, new_regions.name as new_name FROM region INNER JOIN (new_regions INNER JOIN MB_xRef ON new_regions.region_num = MB_xRef.new_cfsa) ON region.region_num = MB_xRef.old_cfsa Where MB_xRef.k_xref = #form.f_muni#

Municipality:

#ucase(rsLookup.municipality)#

Is located in:

Region #rsLookup.new_cfsa# - #rsLookup.new_name#