Filter using a multicategory field?
OK, this is a tricky one (I think).
I have a datalist with a datamaster listing users. When I click on a user it brings up a new datalist with available objects.
So far everything is fine.
Each user have a multicategory field with object IDs.
Now to the tricky part, when the list with available objects are displayed, I want it to only contain objects that match one of the object IDs in the user's multicategory field and objects with status "false".
Any suggestions on how I do it?