>>hi,

thank you for reply,
i need any small sample (tables and forms) to start correct,
i can read it aloan i can see what i can change with my logic to be correct .

pls. if you want to send any sampls,send it as zip.file

Many things are much simpler if you use buffering,
thanks.
best regards>>

To Mohammed Q, sorry Tore, I replied to you instead to Mohammed..

For me, Im using two options about this on VFP6-7 where in autoincrement is not yet supported.
1. I used a table that acts as a counter for billing numbers.
2. I used the recordcount() function after appending a row.

select table1
      append blank
      Store recordcount() to nBill
      If Rlock()
         ..code blocks
      Endif

But theirs a drawback on both of them, for the second one, make sure the other user(first user that appended a new row) has commit the record being appended, otherwise the number sequence is not ordered.


Best solution, upgrade to VFP9 or if you dont want an upgrade at the moment, check sample on tastrade.. has a function that do this...