Many-to-many in a separate table is the way to go on this. I've been through what you're proposing, and it works great for a few weeks, and then you will find yourself having to rebuild the table. Then again a few weeks after that. And so on, over and over. Many-to-many solution means build once, use forever.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon