>I have some ideas which I'm going to implement.
>
>Do you know if there is a way to determine inside the trigger when it's the last record to replace, if, say, we're using replace next 500 command?
>

No, I do not.

A trigger is fired on a record by record basis, just before the changes are actually committed. So, the trigger only knows about that one record.
In the example above, the trigger would be fired 500 times (or less)

But I'm puzzled as to why you would need that info inside the trigger
[snip]