Auto Number to a Record
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?