somebody know how to get the sequence of number after delete data?
i use autonumber for data in table.when one of data deleted, i want the other data sort by sequence number.so what must i do?there are need to use script?if yes,how to use it because i don't know how to use the data script.
If I understand what you mean, it goes something like this:
you have a table for which there is an autonumber, say (record_ID) and it is used as a primary key, and possibly related to other tables. When you delete a record, or a record is added but not saved there are gaps in your numbering and you want to fix this.
to just sort on the current sequence just press the sort ascending button on the tool bar to accomplish that portion.
change the autonumber to a straight numeric, Long Integer and you can assign the missing numbers yourself instead of it assigning it for you.
To fix gaps however - ther is a way, you may have to change the filename in code but check outthis zipped file that will show how to reclaim the skipped numbers first then continue. The program was developed by Neil Squires and should work. It does not in my project yet but it would show how to do it or give others ideas.