shariq1989
Registered User.
- Local time
- Today, 09:02
- Joined
- Jun 6, 2012
- Messages
- 27
When an new overhaul record is entered for a component (ComponentID), I want the overhaul interval (OvhlInterval) for that component to double automatically, so that the application can keep repeating.
Tables:
TblCompletedOverhauls
OvhlID (Pk), ComponentID, DateOvhled
TblComponents
ComponentID, ComponentName, OvhlInterval
What is the best way of doing this?
Tables:
TblCompletedOverhauls
OvhlID (Pk), ComponentID, DateOvhled
TblComponents
ComponentID, ComponentName, OvhlInterval
What is the best way of doing this?