Hi
I have a table that has one column (pump1) controlled by a dbcheckbox. The values can be True, False or null.
I want to insert a row of values into second table when column pump1 value is 'True'. I don't want the trigger to insert a row when other columns of the first table are updated or when the pump1 column value becomes 'False'.
I would appreciate any suggestions as to how to accomplish this.
Thanks in advance.
Bob