AnsweredAssumed Answered

Social media-like tagging in an FMP database

Question asked by billbennettnz on Dec 21, 2009
Latest reply on Dec 22, 2009 by comment_1

Title

Social media-like tagging in an FMP database

Post

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:

 

Item:          item_name

Description: item_description

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. 

 

 

 

Outcomes