Creating a tagging system
I am creating a database to store URL bookmarks and would like to develop a way to tag the records for easy search later. I would like for the user to be able to create the tag, or multiple tags for each record as opposed to having a defined list that they must choose from. I would then like to be able to search for records that match Tag1 and Tag2 or records that are tagged Tag1 or Tag2. How would i do this?
Set up a related table of tag records.
URLTable::__pkURLID = Tags::_fkURLID
The user creates new tag records in a portal to tags on the URLTable layout. If you enter find mode and select or enter a tag in the portal, you'll be able to find all URLTable records that link to the same tag.