Re: [equinox69] Just not understanding how to set up Category menus
Hi equinox69,
I must have misunderstood your original question.
Here's a step by step for you:
1) Create three Multi Record sections: "Inventory", "Manufacturer", and "Model"
2) Modify the Model section and add a "manufacturer" field:
Field Label: Manufacturer
Field Name: manufacturer
Field Type: list
Field Options:
Display As: pulldown
List Options: Get options from database (advanced)
Section Tablename: manufacturers
Use this field for option values: num
Use this field for option labels: title
3) Modify the Inventory section and add a "manufacturer" field with exactly the same settings as above
4) Also, add another field to the Inventory section called "model":
Field Label: Model
Field Name: model
Field Type: list
Field Options:
Display As: pulldown
List Options: Get options from MySQL query (advanced)
Advanced Filter: Refresh list when this field changes: manufacturer
And paste this into the box below "Get options from MySQL query":
SELECT num, title
FROM `<?php echo $TABLE_PREFIX ?>model`
WHERE manufacturer = '<?php echo $ESCAPED_FILTER_VALUE ?>'
5) Test it! Create at least two Manufacturers and at least one Model for each of them, then create an Inventory record. When you select a manufacturer, the options in the model pulldown will change dynamically.
I hope this helps. Please let us know if you have any questions or comments.
All the best,
Chris