Create a drop down Regions - Provinces - City

Hello, I created fields Query Drop Down (single select) connected to the tables included in Db.
On a table there is the list of the regions, in another table I have included a list of the provinces, in another table I have included a list of cities.
I want that when the first field you select a region in the second next field were displayed provinces corrispondentio and then selecting the province were selected municipalities. The tables have fields connection.
Think you can do using the Plugin CB Query Field in conjunction with CB Conditional. Or do you have any suggestions for what I asked.
Unfortunately, the evidence that I did not I have a good result.
Thanks for the support.

Joomla 3.3.6
CB 2.0.4
CB Query Field 4.0.3
CB Conditional 4.0.4

Please describe what exactly you've tried. Did you follow the related tutorials?

www.joomlapolis.com/support/tutorials/107-use-cases/18377-configuring-a-country-field-with-cb-query-field-plugin
www.joomlapolis.com/support/tutorials/107-use-cases/18336-using-cb-conditionals-to-hide-or-show-fields-or-tabs

Heyai Hi, thanks for your reply.
I try to explain the scenario.
I have three tables in the db:
- The first table contains the Italian regions, table name "tbregioni";
- The second table contains the Italian provinces, table name "tbprovince";
- The third table contains the Italian municipalities, table name "tbcomuni".
The three tables have link fields.Watch img Table_Structure.



The result I want to achieve in the registration form and change user profile is that the user select the region from the field of type Query Drop Down (Single Select) and the next field always Query Drop Down (Single Select) displays the corresponding provinces.
I put the stamp of the first field that works, certainly the wrong query on the second. I can not get the right filter.



Thank you for your support and take this opportunity to wish for the new year

If you want to condition the provinces based off the region selected it won't be doable. The Query Drop Down (Single Select) fieldtype pulls its option values from a database query and not from CBs internal table so you will not be able to condition those options. The best you could do is show the Province field when the Region field has a value of any kind selected. Same for City after a Region has been selected. Example of how to show/hide fields using CB Conditionals can be found below.

www.joomlapolis.com/support/tutorials/107-use-cases/18336-using-cb-conditionals-to-hide-or-show-fields-or-tabs

You also can't have the query dynamically update the options of a list based off another fields value. It will take an entire page load for that dropdown to update if you do that. So you're better off having the query display all Regions separated by Province using the optgroup feature.

Your second image has way too much compression and am unable to read the query you're trying to use so I can't advise as to why it isn't working.

Hi Krileon, thanks for your reply.
I want to create a query for the second field (province) which depends on the value of the first field (Region) etc .. I can not do this because they are not very practical for mysql and from what you've written it seems that you can not do .
Can I use CB Conditional to display or not display the field province affected to a value of the field region, this is fine, but when I view the field province can not filter its content, which comes from the DB table, according to what I have typed in the field region.
I read a post it should do more or less what I'm looking for another type of field.
To me it would be okay.
I tried to create the field cb_regioni type text in integration I set this query and it works well.
I created the second field cb_provincia type text, in additions I set this query but it does not work.
Can you tell me where am I wrong?
Obviously the two fields
Query Validation Enabled;
Validate On Successful;
Results Ajax Validation Enabled.

I want to create a query for the second field (province) which depends on the value of the first field (Region) etc .. I can not do this because they are not very practical for mysql and from what you've written it seems that you can not do .

That's doable, but like I explained above it will not update the Provinces when you change the Region until the page has been reloaded. This will be 100% non-functional on registration and be completely awkward for profile edit. At any rate it's done with the below.


I only speak English so I have no idea what those columns even mean, but I assume codiceistatregione_provincia is the Region for the province. In which case you'd make sure it's equal to your Region field value, which is added in using a substitution.

but it does not work.
Can you tell me where am I wrong?
Obviously the two fields
Query Validation Enabled;
Validate On Successful;
Results Ajax Validation Enabled.

I don't understand why you're using query validation. I'm at a total loss as to what you're trying to do now, sorry. Query validation just takes the value of the field and compares it to a database query to see if the value is valid.

I was under the impression you wanted to generate a Select list of Provinces, Regions, and Cities with their options being based off the previous input. This is done using Query Drop Down (Single Select) fieldtypes, not query validation.