Help me understand how dynamic dropdown list works with db

Hi,
I've seen and seek, and search in all the topics I could without the chance of finding what is wrong with the Dropdown filled dynamically with database datas...
I can also see I'm not the only one
It is a very good Job you have done with CF!! 😀 but only that point remain in the darkness of complexity for me...😈 🧐

Now my explanation: :ugeek:
I have a form to make a list of town and postal codes and store them in a table named '#_ville'. So that you can add, modify or del at any time
same for a list of administration. Table named '#_organ'
same for a list of type of house. Table named '#_type'

I want to create a form so that I can pick up in ville, organ and type the information I need to complete a sorte of information card with the name, firstname, address... of the ones in my database. Then I would be able to generate a grafic stat of the people, comparative number of the different towns...😑

I have read the topics and tutos talking of it with no success. :?
all I can say, activating the debug function, I recieve the 'array NULL recieved' error or something like that with my last tried.
So for now I really need a step guide to know what to put where

Let's see the towns sample:
:ugeek:
form to add towns names is 'ajout-ville' .
The same form for the postal codes.
All both work perfect, they fill the table '#_ville' each submitten. So 'General' ant 'Setup' sections are well programed.
Now in the form 'ajout-entree' I have to submit 'nom' (textbox), 'prenom' (textbox), 'ville' (the dropdown taking list from '#_ville/ville'), 'cp' (dropdown list from '#_ville/cp')
as shown in the guide, in setup 'onload' you have 'DBread' with:
Enable Model ID > 'yes'
Table name > '#_ville'
Multi read > 'yes'
Model ID > (not sure what to put in here)
Fields > 'ville,cp'
Order > 'ville'
Group > (NA)
GROUP BY > (NA)

Thank you for your help...😢

so?...

Hi joger,

In your ville drop-down you need to configure the 'Dynamic Data' tab to match the data you are reading from the table.

BUT I'm not sure about the data you are loading? How do you link the Code Postale to the Ville? Don't you need the id of the Ville from the table to identify it?

Bob

Thanks Bob for your answer...

In your ville drop-down you need to configure the 'Dynamic Data' tab to match the data you are reading from the table.

😲 Y...Yess... :? OK...😑 Go on, tell me what exactely what I am supposed to fill with...

BUT I'm not sure about the data you are loading? How do you link the Code Postale to the Ville? Don't you need the id of the Ville from the table to identify it?

Ok... as I said, the 'villes' and 'cp' are in the same table named 'cpville'.
Is this the right way to proceed?
I filled the 'Dynamic Data' tab like this:

Enabled -> yes
Data Path-> cpville
Value key-> cp
Text key-> ville

errata... table is named "#_ville" so data path is "#_ville"

Hi joger,

Sorry, but I am completely lost here. I'm pretty certain that you can't have a table named #_xxx or use that as a model name.

Joomla! uses the #_ prefix as a placeholder for the actual prefix used in your database so it replaces the #_ in #__tablename to give e.g. pqrs_tablename (this is to support the use of random prefixes in place of the old 'jos_' prefix.

Bob

Hey! thank you very much! it worked!
the problem came effectively from the prefix #_
I renamed all the tables removing the prefix then it worked!
Than you very much Bob GreyHead