Writing a delete trigger

I am wanting to write a delete trigger that when fired on table a looks to see if what the current highest value of a certain column is after the delete and if it has changed (ie the row deleted contain that value) a update is made to table b with value from the row which now contains this new highest value.

since the trigger cannot select from the table that fired it does anyone have any good ideas?

thanks
Chris Received on Thu Apr 18 1996 - 00:00:00 CEST