Auto Number to a Record

Asked By DavidSBernal 10 points N/A Posted on - 06/04/2013

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?

• Status: Open
• Question Views: 725
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Davidson Mudge 0 points N/A #171038

Auto Number to a Record

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.

About Davidson Mudge

Questions
3

Answers
500

Best Answers
197

• Vote Up 0 Vote Down

• Posted on - 06/05/2013
• Question Category: Misc Software