Hi,
I need some help with a multi selection form field.

I see the posts pointing us to www.j-cook.pro/index.php/r/relations - but I don't understand.

Attached is my database schematic. For the Pollutant_storage_type field I would like a group of checkboxes so the user can select one or more values - such as "Wet", "Dry", "Online", "Offline".

Can somebody point me in the right direction?

(PS: it would be helpful if this forum allowed png and jpg files)

Hi,

You have to create a link-table.
From your schema you have a FK (Pollutant_storage_type) directly linked to an ID in Pollutant_storage_types.
Therefore, you can only choose 1

Steps:
- Remove FK from devices table
- Create a table devices_storagetypes
- In there put an FK to devices and an FK to pollutant_storage_types
- Edit the collection view(s) if needed (there should be a cross table now, you might need to refresh the builder)
- Edit the item view(s), drag the relation to the form

This does not create a set of checkboxes however, this creates a multiple select (like the tags in Joomla)

Thanks Romkabouter - that works well.

For others also trying to do this ... attached is an updated schematic...