Conditional Fields

Hi,
I have searched the forum for related posts but I am still in doubt. I have the following fields: Region->Country->State->City.
Region field is visible. The rest appear conditionally if not empty, in the sequence shown above. I saw somewhere in the forum that the fields do not populate dynamically. I need to know how to implement the following:

QUESTION 1
1. FROM `#__comprofiler_countries` Region field to show ORDER BY `country_region` and `country_sub_region`.
2. Once the user selects a `country_sub_region` => the Country field appears showing the countries related to the specific `country_sub_region`.
3. Once the user selects one of the countries shown for the specific `country_sub_region` => the State field appears FROM `#__comprofiler_provinces` showing the States related to the specific `country_name`.
4. Once the user selects one of the States shown for the specific Country => the City field appears showing the Cities related to the specific `province_name`. (As for the 4th step, I will implement if/when I manage to find all the cities. An alternative to this could be for the user to input text in the field.)

The fields are shown/hide properly

QUESTION 2

Although the user might select North America->USA->Connecticut->Bridgeport, in case there is no member in the database from Bridgeport, I would like the system to show members from Connecticut.

Thank you

QUESTION 1
1. FROM `#__comprofiler_countries` Region field to show ORDER BY `country_region` and `country_sub_region`.
2. Once the user selects a `country_sub_region` => the Country field appears showing the countries related to the specific `country_sub_region`.
3. Once the user selects one of the countries shown for the specific `country_sub_region` => the State field appears FROM `#__comprofiler_provinces` showing the States related to the specific `country_name`.
4. Once the user selects one of the States shown for the specific Country => the City field appears showing the Cities related to the specific `province_name`. (As for the 4th step, I will implement if/when I manage to find all the cities. An alternative to this could be for the user to input text in the field.)

Use CB Query Field and build your select field from those database tables. Next be sure your query is dependent on the previous field. Now use CB Core Fields Ajax and configure the fields Update On to be for the previous field. This will for example cause Country to refresh when Region changes its value. An example of this using Query Autocomplete against text fields is included in CB Quickstart if CBSubs is installed.

Although the user might select North America->USA->Connecticut->Bridgeport, in case there is no member in the database from Bridgeport, I would like the system to show members from Connecticut.

Not sure what you mean by this. Usually best to show a text field for them to type their city if it's missing, which you can do by outputting a Other option then conditioning a text field to display.

Following your instructions, I've done most of it and it works fine, thank you.

Here is the issue I am facing:
I have 2 fields `cb_cat_bus` and `cb_subcat_bus` (depended on the former). I add the following query to get the table data

`cb_cat_bus` query works fine:
`cb_subcat_bus` query doesn't:

`cb_subcat_bus` query doesn't:

I assume that's a Code Select provided by CB Code Field. You don't need a Code Select for that. You can use a Query Select as follows.


Now this field would have Update On set to cb_cat_bus under Integrations > CB Core Fields Ajax. This will cause it to refresh its display when cb_cat_bus changes value. If you still want to use a Code Select then configure the Update On and make the following change.

FROM: TO: