If you would like to maintain unique i.d. numbers that are sequential, here is a rough outline without code of how I handle this. Create a separate table to handle the i.d. number. Two fields, one for the number and one logical. When the application needs a number it goes to the table grabs a number and turns the logical to .t. and appends a new record incrementing the number by one and setting the logical to .f. for the next user. If the user completes the form and submits without cancelling or exiting it goes back to the table and deletes the record with that i.d. number, (to keep table as small as possible). If the user cancels and decides not to complete the entry it goes back to the table and turns the logical back to .f. indicating it is not used and is available for re-use.