Hi Paul,
Thanks for giving us more details. It looks like your MAKE and MODEL list fields only uses the List Option "Use options listed below". As I mentioned before, we need the Make and Model to have their own sections.
I've created an example with screenshots and hopefully it will help you on setting it up.
First, I've created a "Make" section with just a title field.
Next, I've created the "Model" section with title and "Make" drop down list field. The "Make' field came from the "Make" section. See "model_makeField.png".
Then I've added sample Model records, see "model_addRecord.png". In the screenshot, we're associating model "Blaster" to "Peugeot".
After that, I've created the "Bikes" section with title, make, and model fields. The List options for the Make field of Bikes section is the same as the Model section's Make field: Get options from database (advanced).
Finally, for the model field, I used the List options "Get options from MySQL query (advanced)" that uses the advanced filter functionality. See "bike_modelField.png".
MySql query:
SELECT num, title FROM `<?php echo $TABLE_PREFIX ?>model` WHERE make = '<?php echo $ESCAPED_FILTER_VALUE ?>'
The $ESCAPED_FILTER_VALUE is the record num of the selected item in the Make field of Bikes section. So the query means select/load the models where their make is equals to the selected make value. See "bike_addRecord1.png" and "bike_addRecord2.png.
If you're using the list options value (ex. MB-230-1 for Blaster) in the front end, you might need to change it to Blaster's model section record num.
Hope this helps!
Cheers!
Daryl Maximo
PHP Programmer - interactivetools.com