>>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

sure -- the pseudocode is leftover from 2.0 work...