Calendar and Sheduler, how to?

[eluser]Eric Cope[/eluser]
Here is a starting point for the event databases.
table - eventInfo

Code:

eventID eventTitle eventType customerName recurrance
0       Title 1    Wedding   Bill Smith   single
1       Title 2    Birthday  Jane Smith   annually
2       Title 3    Meeting   Bill Jones   Monthly

table - events

Code:

eventID date                location
0       2007-06-02 07:15:00 1st Street and Central Ave.
1       2007-03-21 13:45:00 2nd Street and Main Street
2       2007-01-01 05:15:00 3rd Street and Gainey Road
2       2007-02-01 05:15:00 3rd Street and Gainey Road
2       2007-03-01 06:15:00 3rd Street and Gainey Road
2       2007-04-01 06:15:00 3rd Street and Gainey Road
...

When you add a single event, you place a single record with information regarding the event in the top table. Then, you add a record to the second table about the events date and time, and location, things specfic to the specific event. So if you have a re-occuring event (monthly party), then add an event entry for each date, for as long as you want (I did it for 30 years). Does this clear things up?