Many to Many field select all / none

[eclectus]

Is it possible to Select All or Clear All when inside a Many to Many field?

This is extremely important, for example - where we ran into this issue - we have a Category many to many field, and an Item many to many field. When certain categories are selected, the Item list is Auto-filled to only contain items that belong to the selected categories. If a person selects categories and selects no items (there could be 100s of items in a category) it is considered that all items in that category are selected. Since there is no entry called 'All Items' in a many to many field, and we have to use the Items list for an automation, we automatically select all items in the filtered list. However, if the user wants to edit that field, they need to uncheck all items we automatically checked in order to create a selection.

If you have an idea how to implement this - great. If not, I would put that high on the priority for future feature list, either have a right-click to Select All or Clear All, or have a check box as part of the many-to-many field window where you can select/unselect all.

[ZevToledano]

Currently you can select all/unselect all using ctrl-A ctrl-D but only if the 'Advanced Search' is on for that table. I.e. in Tools/Options/Advanced/Tables for Advanced Search.

We will make the simple/default list that appears also work with ctrl-A/D in a future version.