Social media-like tagging in an FMP database
I'm running FMP 10 on WIndows 7, but I don't think any of that's relevant to my question.
My database is very simple. It has three fields:
Tags: attribute1, (possibly followed by one or more additional attributes; attibute2, attribute3 etc)
Each item is unique and has a unique description.
There are two tables. The first with fields: Item, Description, Tags.
The second is just a list of Tags.
I've then created a Value List which contains the full list of tags, this displays on the form for the main table as a Radio Button Set.
I can click individual attributes in the Radio Button Set - but only one for each item. I'd like to be able to store multiple tags in the Tags field, these could be comma separated or space separated (it isn't important which).
At a guess I'd say this approach is so trivial it probably has been done a thousand times before, I'm afraid I don't even know where to start looking.