Hello,
I have added a select (dynamic field) and used the following to retrieve my values out of a table called 'cities':
Query: Free
SQL Query:
SELECT city AS TEXT, city AS VALUE
FROM cities
ORDER BY city ASC;
Storage: standard | article | city

When adding articles I can select and choose a value but:
Although in cck_store_item_content I can see the column name 'city', there is nothing saved inside when saving articles???

I have looked through at least ten videos, in the forum was reading for hours, and even tried different storage.
Nothing seems to be saving the values.
Can anyone help me on my way?

----
SOLVED!
To pick up a list from an external table (custom added to joomla db with phpmyadmin),
I have my dynamic (select) field in the form for submitting articles.
SQL: Free

I changed my SQL query to:
SELECT city AS value
FROM cities
ORDER BY gemeente ASC;
Storage: standard | article | city

Then I had to retrieve my value in intro view:
Text Field: city-value
Storage: standard | article | city

And now all displays well!