I am confused that if I create a recurring appointment that the appointments are not created as separate records. It appears that the system is making note of the recurrence pattern in a separate table and displaying the results in the calendar object. Unfortunately, these appointment objects do not exist and cannot be altered without changing the entire record.
If a user sets an appointment with a recurrence value of weekly every monday, tuesday and wednesday and the appoint has a staff member assigned to it the system will generate all of the appointments on the calendar but if you need to assign different staff members (in no particular order) to the calendar events then the data is only modified on the original appointment record. This is also not useful when attempting to display the data in a regular query as there is nothing that will display the total appointment records or the recurrence pattern that has been selected on an individual appointment record.
With this style of recurring records the records do not exist and therefore cannot be modified individually. Is there a way to select a pattern and also have the system generate the records so that there is a unique record created for each event?
I also noticed in my test environment that the beginning and ending dates start in the following format:
11/12/2009 08:00:00 AM
but are changed to the following format after a recurrence pattern is selected:
11/12/109 08:00:00 AM
The format being used on these attributes is MM/dd/yyyy hh:mm:ss a