A couple issues doing it that way (Besides still not getting it to work at all with templates)
Can you have two fields grouped individually in a sql recordset? Seems I can group either the province or the city but not both.
If I group the city one I get 4900 items in my province drop menu - about 3500 of one and about 1000 of another and a few others scattered in there.
If I group the province I get hundreds of listings in the drop down for the same city.
So what I tried to do was to create a second table with just the province codes to use in the parent list. Will that work? If so how, as it doesn't really state clearly in the docs what fields should be selected in the extension UI.