Screen shots added as pngs this time instead of a zip, and extraneous tags removed that were added due to cutting and pasting from an email
Here is how we would like the store locator form to work:
Default drop down options for State/Province would list US states (plus Puerto Rico and District of Columbia) For reference, the majority of our firm’s sales are in the US, so seems appropriate to make the US states the default.
If a viewer selects a country for which data exists in the “state” field of the database, the state/province/territory for the specific country (Canada, Australia, Mexico, etc) would populate as drop down options in the STATE/PROVINCE select box
Also, is it feasible to add Puerto Rico as both a state and a country. While Puerto Rico is not a country, it seems like listing it both ways would increase its “findability”