johnqzsmith
Registered User.
- Local time
- , 22:32
- Joined
- Apr 25, 2004
- Messages
- 13
I am struggling with a solution to this problem involving maintaining a calendar or central list of Events.
I have 5-6 "Event" tables ( e.g., Social, Meetings, Programs, etc.) each of which I would like to take the date and time from, along with a brief description, and add those fields to a simple Calendar (EventsList) table. Conversely, if the event is cancelled -- done through the particular event form and table (once again: Social, Meetings, etc.) -- I would like to have the corresponding record in the Calendar (EventList) table be deleted as well. Note that each of the Event tables are different from each other.
I didn't think it would be that difficult, but find myself struggling with this beyond a reasonable time. Any help in accomplishing this or "kick-starting" me would be greatly appreciated.
Thanks in advance from a brand new member.
JohnQ
I have 5-6 "Event" tables ( e.g., Social, Meetings, Programs, etc.) each of which I would like to take the date and time from, along with a brief description, and add those fields to a simple Calendar (EventsList) table. Conversely, if the event is cancelled -- done through the particular event form and table (once again: Social, Meetings, etc.) -- I would like to have the corresponding record in the Calendar (EventList) table be deleted as well. Note that each of the Event tables are different from each other.
I didn't think it would be that difficult, but find myself struggling with this beyond a reasonable time. Any help in accomplishing this or "kick-starting" me would be greatly appreciated.
Thanks in advance from a brand new member.
JohnQ