This may be a simple question, so forgive me in advance, but how do you assign multiple categories in a single field for SQL Server data?
Example, I have in one table:
ID, int (PK)
CategoryID, int (FK to a CategoryID table)
Then, in the other CategoryID table, I have:
CategoryID, int (PK)
How do I assign on record in the first table to have multiple categories associated with it?
Thus, say the record is:
[here i want to have 'Admin, User, Writer' in associated to this.
The other table would be:
3 Power User
Do I just put 1,2,4 in the one area? I'm sure there is an easy methodology for this, but I'm not getting the best way tot do this without having to crate a boolian set of columns for each category in the primary table.
This data will eventually be used to display on an ASP.NET page.