Auto Number to a Record

Asked By 10 points N/A Posted on -
qa-featured

I have created a main table that has an auto number primary index (Main ID) that helps me sort my reports in the order in which they are created. I know I shouldn’t play around with the auto number so I added a Sort Order field with chronological numbers so that I can insert a record in the main table and not at the end. This being said I was supposed to assign Sort Order +1 to a new order. Do you think that my method will work like auto number does? Is there anyone that can help me with a code so that I can insert a record of about 15 seconds between record 9 and 10?

SHARE
Answered By 0 points N/A #171038

Auto Number to a Record

qa-featured

Hi David,

                This is a great idea with adding records at the beginning assuming that it will auto update then you will think that the record number will increment. However, in the long run it will produce conflict once your data gets bigger and it will be harder to add 1 to all the subsequent columns. If it will not be much of a work you can add new data at the bottom you can also audit this way much easier.

Related Questions