[kbs666]

What you're talking about in database speak is many to many relationships. Databases don't tend to handle many to many relationships well at all. I'm not saying it can't be done just that there is quite likely a performance price to be paid for doing so.