Hi Team, how do I create a check field which is linked to a category? so a speaker bio is created, and from the category section, we should be able to select multiple categories that the speaker is linked to eg, Speaker, Author, Entrepreneur etc I’m able to get a drop-down working but can only select one category like this but I need to be able to select multiple categories.
please advise
thanks
J
ok fab that worked however, when i now navigate to category its not showing the associated speaker (if a speaker is in more then one category) , single category speakers are showing so its not filtering it.
eg if I select category > entrepreneur > then it shows a user who has only an entrepreneur as category
if I select business owner > its not show the speaker (even though that speaker is linked to business owner and another category )
(I can see in the data sheet that a user who has more than one category is not listed in either category, but if a user has one category they are visible in that data field. in the related filed I have select multiple match). i must be missing something
thanks for you help
When you assign multiple categories to a Speaker, you should see that the destination column will contain a comma separated list of the selected categories. What you need to do is coerce that into an array, and then relate it back to your Categories table. Do that as follows:
Side note: for a more robust solution, I’d recommend adding a RowID column to your Categories table, and write this value via the Choice component instead of the Category name. Then if you ever edit the name of a Category, nothing will break.
wow that’s soooooo cool thanks that worked , the filter now works. 
