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.
Topic Options
Post Options
Thanks(0)
