Hi,
I have a table called healthchecks
it has 2 fields, one call sentdate, the other called nextauditdate.
I want to create a trigger which updates the nextauditdate to sentdate plus 1 month whenever a new record is inserted.
help much appreciated.
Joe
I have a table called healthchecks
it has 2 fields, one call sentdate, the other called nextauditdate.
I want to create a trigger which updates the nextauditdate to sentdate plus 1 month whenever a new record is inserted.
help much appreciated.
Joe