I am adding some features to a Sales claendar at work.

One of the things I am trying to add is recurring events. But as always I am running into a brick wall.

My question is this. My idea is, on recurring events to write out an event record according to date span, but this could be potentially bad. I mean if someone says everyday I want an event on my calendar for the next 3 years to remind me to get the paper, it would potentially add about 1,000 records to the events table. Now 1,000 records isn't bad, but I can see the count getting big quickly. Also if the person goes back in later and says now I only want to be reminded on Monday and Tuesdays only, I would either have to go in and check all the events already added and delete the ones that don't fit or delete all and then re-add the new events.

I thought of having all the info in 1 record and then doing some vbscript to see if an event needs to show up in other places, but it doesn't seem as exact as having a record for each event.

I would like someones opinion about how to set this up. Thanks in advance for your help and speedy reply.

In this case I will go with at least 2 tables. First with the event description and second - to set events' details, like:

EventID (reffers to the first table' event ID)
Date Start
Date End
Time
Periodicity (daily, mondays only, etc. Or just create 7 boolean columns for each day of week and check them if event is applicable for this day of week)