Re: FN-FORUM: Database structure question

date posted 30th April 2007 14:15

On Monday 30 April 2007 14:03, Paul Cooper wrote:

> This works fine except my client has mentioned he would like to have
> the ability to add a course to more than 1 Course Category. Currently
> to do this, he has to add the course details twice so that it appears
> under 2 category listings.

Not sure which rdbms you are using, mysql supports the 'set' datatype
see http://dev.mysql.com/doc/refman/5.0/en/set.html

Using that or similar you could make the CourseCategoryID col in
tblCourseListings to be of type set and thus a course could be of multiple
types.

Cheers
IanR
--
---
http://narian.org.uk GSM: 07906-204-878 Landline: 01382 805 079