Hi everybody!
I've exactly the same problem...
I searched in this forum (and on other websites) articles referencing to this subject but I unfortunately have not found anything.
My PROBLEM is: I have created in my database a table with these fields:
- "country"; "area"; "city".
I now have to create a multiple choice (select list) to let a registered user specify where he lives. All this must have the select list logically connected each others.
My SCOPE would be to connect one specific "country" to the following list of "areas" related to that "country". Why? Well, I would like that, in the registration page, when a user selects (for example) the country "Italy", then he would be forced in the following field to select only the Italian areas and not French or Spanish ones.
And so go on creating some logical links between "areas" and "cities".
QUESTION: is it possible to create a logical connection among the fields inside the admin area of Joomla 1.0 or Joomla 1.5?! I instead need an external tool? Do you have any idea about it?
I have found something on the web but it's almost separated from the joomla database; instead I would really like to interact with joomla database.
Waiting for your answers. Hoping hearing you soon.
Sorry for my english...
Joomla CB rulez!