Help Please!
I'm just trying to do this with the Dynamic cascading fields:
Only one flat table, : [id] [make] [model] [year] [price]
I want to populate the first field with make, the second with model (models of the selected make )
I used the following as my for the first (make) field:
SELECT DISTINCT make AS text, make AS value FROM #__cck_store_form_mcars
I could use the construct for the second field (model) with make as the parent and it works but gives duplicates.
I tried:
SELECT DISTINCT model AS text, model AS value FROM #__cck_store_form_mcars WHERE make=[parent]
for the second, but it did not populate with the models.
What would be the correct syntax for the free sql statement?