I have 2 tables, one called Reminders and the other one is named Preset Events. The tables are not joined. The Preset Events table mirrors the Reminder’s table except it does not contain the Date field or the Person’s ID associated with the event. The Preset Event table contains default values for a given event, i.e. for a wedding anniversary, I may want to be reminded yearly and given a notice 2 weeks before the event. The duration for this single event is to remind me for the next 10 years. Another example is after closing a transaction, I want to be reminded a week after the event to send a thank you note. Some events would be recurring for different persons (wedding anniversaries for example) whereas some reminders may be just a onetime occurrence.
With over 40 different events, the purpose of the Preset Events table is to maintain consistency and speed of entry. Currently, I can enter a Reminder in either of 2 ways; manually in the Reminders table using a form of course or by selecting a preset event from a combo box whose record source is the Preset Events table. After selecting a preset event from the combo box, the default values are then copied to the Reminder’s table from the Preset Events table where I can then just enter the date to be reminded.
Is my method a good strategy, or is there a better way to accomplish this? Your thoughts would be greatly appreciated.
- tblReminders
-
ReminderID PK
-
rPersonID
-
rDate
-
rEvent
-
rLength
-
rDuration
-
- tblPresetEvents
-
PresetID PK
-
peEvent
-
peLength
-
peDuration