"Tagging" Records

[Jonathan Harrison]

I have a table that holds a list of problems that need to be fixed. I would like to tag each of these problems similar to how blog posts are tagged so that I can easily retrieve all records tagged with "office space" or "electrical" in the future. Each record will be tagged with mulitple tags and When creating a new record, I would like users to be able to select from a list box that auto populates with all previously used tags and add their own tags if need be. I have tried using a list box and a combo box for this but have run into issues with both. Can someone please point me in the right direction?

Thanks!

 

[jackd]

Do you have a list of Tags? You mention "office space" or "electrical" and these may be related in your context. Is there some sort of grouping of the potential "tags"? Is there a hierarchy to "tags"?

I think before the assignment, you'll have to -at least conceptually - rationalize what these "tags" are meant to represent.

Table wise, you will have

Problem
ProblemId
ProblemDesc

Tag
TagId
TagName
....other attributes

Then a junction table to resolve Many to Many

Assignments
ProblemId + TagId (composite unique index)

Hope this gets you started.

 

[Jonathan Harrison]

I appear to have resolved this issue. Thanks anyways.

 

[jackd]

Perhaps you could show or describe your solution to help others who may have a similar issue.

 

[HiTechCoach]

I would also like to see your solution.