Hi!
When I have a many-to-many relationsship in my DB, I have allways used an intermediate table with two foreign keys to link the two other tables together, because this was the "right" way to do it.
Now one of my friends suggested, that I just in one of the tables have a comma seperated field like this: foreignKey1,foreignKey2...
I couldn't find any disadvantages to this solution, but surely there must be some.. - Anybody?
- Anders
When I have a many-to-many relationsship in my DB, I have allways used an intermediate table with two foreign keys to link the two other tables together, because this was the "right" way to do it.
Now one of my friends suggested, that I just in one of the tables have a comma seperated field like this: foreignKey1,foreignKey2...
I couldn't find any disadvantages to this solution, but surely there must be some.. - Anybody?
- Anders