Mike, I have found that your first idea works best as it gives greater control over editing regular events as individual events if required. But what you do is enter them as single events but at the same time add an ID to each event that ties them all together if you ever want to go back and edit them as a group in future.
So when you enter a regular event, you enter the recurring interval, say weekly, then a date range, starting from and ending on and when they are added into the db, each occurrence has a unique id (so you can edit just one occurrence if necessary) but make sure each occurrence has a shared unique id so the db ends up like this: ID EVENT REG_ID 1 cfug meeting 1 2 cfug meeting 1 3 cfug meeting 1 4 cfug meeting 1 5 cfug meeting 1 Make sense? Good luck, Steve c -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Kear Sent: Wednesday, 11 February 2004 2:30 PM To: CFAussie Mailing List Subject: [cfaussie] A less basic calendar I've been looking at a calendar app on and off for ages and never really resolved how to handle regular or repetitive events. (such as every Monday or every third Saturday or Every fortnight). Has anyone had to handle this sort of issue? I want the app to be able to handle on-off events, but also regular events. One approach I've thought of is to have the user enter "every Monday" (say) by clicking on options on the form (to ensure consistent entry) and then have the processing page enter a series of single events going out the next year. Another approach is to enter the basic information "every Monday" into a "regular events" table and at the display time have the display processing page query the one-off events, and also the regular events table then use query of a query to combine the two lists. Does anyone else have an opinion here? Or perhaps another approach? Does anyone know now other calendar apps like Outlook handle this? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
