Re: FN-FORUM: Database structure question

date posted 30th April 2007 15:56

Thanks Ian / Graham.

OK I guess I'll go for the link table. The reason I wasn't sure was
that I vaguely remember doing database schemas at college (long tome
ago) and defining links as one to many, many to many etc. (with 'many'
denoted as 8s on their side). Since then I've never devloped a
database app (where you define relationships) but just used databases
for web sites to only store data (and do the linking with SQL).

Ian - It's SQL Server. I'm not sure if you meant making
CourseCategoryID in tblCourses a 'set' datatype. The way you
mentioned would still mean adding a link table. Anyway if it's normal
to use a link table I'll just do that as it makes sense to me.

Thanks again.
Paul