Upgrade to VFP9 and use an AUTOINC field.
>Hi all, I need a method to compute an automatic account number (one-up-count) for each new record (append blank). Old method (DOS) was to go to bottom of table, then get last account number, compute next account number, commit immediately (save) and move on. With multiple users this worked fine because commit (skip-1) was immediate. In windows, the commit seems to be held in a buffer so multiple user all seem to compute the same next record number because commit (save) is still pending. Any ideas?
>
>Dallas