Table I'm building

Question

I am creating a "Class" table to hold training class
information for my company. Some classes are held on a single date.
Others are held on multiple dates like 5/12 - 5/16. Some are held
over a two week time frame. All are held on business days, no
weekend dates. How should I record this? At first I thought about
putting in fields labeled Date1, Date2, etc but then I had second
thoughts that might not be the best way. Can anyone give me some
advice on this? I am using CF8 and SQL Server 2000.

The fields that I have in my "Class" table thus far are:

ClassID
VendorID
InstructorID
...

Thanks very much.

Dan_Bracuk · Accepted Answer

The most flexible approach would be a Class_dates table with two fields, Class_id and date. Add a record for each date the class runs.

You may also give consideration for maintainig a table of dates, since "business days" usually exclued holidays.

Newsgroup_User · Answer

Dan Bracuk wrote:> The most flexible approach would be a Class_dates tablewith two fields, > Class_id and date. Add a record for each date the classruns.This is what I would suggest as well. This is definitely themost flexible. For example, it would be easy to add time to thistable so that a class that is 2 and 1/2 days could easily be recorded.I.E.Class_DatesclassID classDate startTime endTimeabc123 5/20/2008 8:00 15:00abc123 5/21/2008 8:00 15:00abc123 5/22/2008 8:00 11:00xyz890 5/30/2008 8:00 10:00

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded