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.
Expand|Select|Wrap|Line Numbers
- tblReminders
- ReminderID PK
- rPersonID
- rDate
- rEvent
- rLength
- rDuration
- tblPresetEvents
- PresetID PK
- peEvent
- peLength
- peDuration