Multi-select categories

Question

I am creating a database of podcast shows. I have a Shows table with all the attributes of each show. One of the attributes is category, and each show can fall under one or many categories. I have a list of 150 categories. What is the best way for me to achieve this functionality (from a table perspective and from a data entry form perspective?)

------------------------------
Myoshia Boykin-Anderson
------------------------------

MarkShnierYou · Answer

I suggest a table of the 150 Categories and then a middle join table called Podcast Categories with a Relationships for 1 Podcast has many Podcast Categories and another relationship where 1 Categories has many Podcast Categories.

That will give you the flexibility you need for reporting.

If the data entry is too slow for you that way I can can set up a faster way for you to do the data entry, but that would take a one on one session for about an hour. (Contact me me by email to discuss).

You can then roll up the combined text summary of the podcast categories up to the Podcast and then there are ways to present that field in a more attractive format and also use it as a Dynamic filter. Feel free to post back with questions here about that or contract me for some quick on on one assistance.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community