Table design for planning schedule

[gerard1979]

I have a little design problem.
I have a Ref. from a Ordertable. This Ref. had to be scheduled in a daterange. Daterange can be 31-12-02 till 3-01-02 but also can be 31-12-02, 3-01-02 till 5-01-02, 11-01-02.
What's the best method to save this?
I tried:
tblSchedule:
OrderRef (foreign key from OrderTable)
Date1 (start date)
Date2 (end date)
Team (who works it out)

To save the records like
Ordernr Date1 Date2 Team
1 31-12-02 3-12-02 1
2 31-12-02 31-12-02 2
2 3-01-02 5-01-02 2
2 11-01-02 11-01-02 2

I'm not sure if this the best solution but.....
maybe somebody knows a better way,

Thanx in advance,

Gerard

 

[JeremyNYC]

What about just one date field and one record per applicable date? Seems like it would be simpler to write queries on that, and since you're already going to have to code for looping through the input and adding records, it seems like this wouldn't add much to the coding required.

Just a thought, certainly not thought out to any great degree.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.