>when they save the invoice, add code to update the invoice counter
>
>something like
>
>if this.addrecord
> savebutton::click
> select uniqueid
> replace uniqueid.idnumber with uniqueid.idnumber + 1
>endif

IMHO this is better dealt with in the stored procedures (ie the default value) this way the primery key will not be violated...

Arnon