RE: array vs. more table cells

2003-08-28 Thread Mark Richards
Grant, >From my old relational database days we'd create a table of courses and index this so it could be linked from your semester table. This way, you'd have a single entry for each course. Should the course change, the maintenance nightmare is alleviated by only having to change the course en

array vs. more table cells

2003-08-28 Thread Grant Cooper
I'm building a program calendar describing each Year's courses. I have a field for a semester and it's current courses in one cell separated by a ",". When I go to print this out I create an array out of the cell than do it's sorting. Or Should I just take the time and create a new table and sepa