keywords/tags system with links
for my cocktail database I wanted to add keywords/tags (sweet, bitter, fruity, ...) that I could assign to different drinks.
I'd love to have the possibility to click on one keyword that will give me a list of all the drinks with that keyword.
I've created a keyword table with the cocktails ID linked and the keyword. However, I'd like the keywords to be displayed one after another. How would I be able to do this and have a seperate "go to related record" for each individual keyword?