1. Copy all records up the insertion point to a temp file 2. add the new record to the temp file 3. copy all the rest of the records to the tmp file 4. Erase the original file 5. rename the temp file to the ooriginal name 6. recreate any indexes for the original fileIt should be obvious that if the record count gets even moderate this will become and major performance bottle neck.
1. Add a record to the end of the fila 2. Update the indexesNow you simply set the proper index in control and your records are in the order you want them.