i'm using a form to enter records into a table. Each record is assigned the next available number, ie. 1,2,3, etc. when i'm in the form and click on "add new record" is there a way to assign the next number to the record without having to use the "autonumber" function?
i need to start at 1 and work my way up, when i use the autonumber function it works well, unless i have to delete a record. ie) i had 15 records in my table(assigned numbers 1-15), i deleted all the records to start over, but the table still assigns 16 as the next number where i'd like it to start at 1 again.
i need to start at 1 and work my way up, when i use the autonumber function it works well, unless i have to delete a record. ie) i had 15 records in my table(assigned numbers 1-15), i deleted all the records to start over, but the table still assigns 16 as the next number where i'd like it to start at 1 again.
