In my invoice form, I have a readonly field which shows invoice number. The code in the gotfocus is :
sele inv
nInvno=inv.invno
repl inv.invno with inv.invno+1flush
but somtimes my client end up two invoices with same invoice number. The system is used over the network. How can I stop this. Your input will appreciated.