I'm trying to marry my cb user fields with mijoshop/opencart customer fields. I have the mijoshop developer insisting that the state/province field cannot simply be a single select drop down as I currently have.

He advises my cb_country field is now compatible (thank you), however I need to be able to have a similar Query Drop Down for state/province (province_iso_code), as is used, I presume, for the CB Subs Geographical Country and State / Province entries forming a Geographic Zone.

Can I achieve this for a cb user field?



<select aria-invalid="false" name="province_iso_code" id="province_iso_code" class="form-control" title="province_iso_code|The State / Province is optional.">
<option value="" id="province_iso_code__cbf0" selected="selected">All</option>
<option value="AU-ACT" id="province_iso_code__cbf1">Australian Capital Territory</option>
<option value="AU-NSW" id="province_iso_code__cbf2">New South Wales</option>
<option value="AU-NT" id="province_iso_code__cbf3">Northern Territory</option>
<option value="AU-QLD" id="province_iso_code__cbf4">Queensland</option>
<option value="AU-SA" id="province_iso_code__cbf5">South Australia</option>
<option value="AU-TAS" id="province_iso_code__cbf6">Tasmania</option>
<option value="AU-VIC" id="province_iso_code__cbf7">Victoria</option>
<option value="AU-WA" id="province_iso_code__cbf8">Western Australia</option>
</select>

I'm getting very close... the state/province drop down works, however it lists the state/province of every country. This is despite having already selected a particular country in my cb_country field.

Is it posible to make the field dependent on what country has been selected so that only that country's state/province is displayed. (as does the CB Subs Geographical Country and State / Province entries).

Perhaps I need to rename my field? cb_state

Can you please provide me with the actual WHERE statement and how I should add it?

Strange how it won't ajax update! Why can it be achieved when selecting a country in CB Subs Geographical Country and State / Province entries and not in this instance?