There is a table with the records representing, lets call it, "tasks"(a lot of various forms and reports around this table). I want to assign each task a category. Each task must be able to be associated with more than one category. Current number of categories- 31. Looking for the best way to do it. Tried several ways. Assigning is easy (started from creation of the 32 fields in each "task" record, next approach was to create table linked to tasks table with combo box picking the value from the Category table). Problems came in both cases, when I wanted to filter the big archive table with "tasks" based on the multiple categories choice.
I'm sure there is an elegant way, which can save me a lot of time for further research.
Thanks in advance and best regards,