Posted May 20, 2004 in Databases.
I've been pondering some of the complexities of a CMS redesign, and I've come upon a stumbling block. I'm something of a database newbie, so I thought I'd ask my learned readers.
In my current system, posts can belong to a single category. Each post record has a category identification number that points to a category record. How do I give each post the chance to belong to 1 or more categories? I realize this will probably require another table.