Hi John,
Thanks for reply, however, I was hoping to do this in a separate
field by itself. I will study your example to guide me.
have a great day! Becky
Hi Becky ----
>
>PROCEDURE genInvoice
>LPARAMETERS cLastInvNo
>cNewInvNo=""
>IF BETWEEN(RIGHT(cLastInvNo,1),"0","9")
> cNewInvNo=cLastInvNo+"A"
>ELSE
> cNewInvNo=LEFT(LEN(cLastInvNo)-1)+CHR(ASC(RIGHT(cLastInvNo,1))+1)
>ENDIF
>RETURN cNewInvno
>
>This will cause the invoice number to cycle in the following manner:
>
>10001
>10001A
>10001B
>etc....
>
>
>
>>
>>I have a pageframe which displays a new record with an
>>invoice number. I now want to do an invoice number with
>>an A,B,C following the invoice number in a separate field.
>>
>>What is the best way to make additional copies of the same
>>invoice go from A to B, etc. each time a new invoice is added?
>>
>>Thanks and have a great day!
>>
>>Becky