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?