Luke,
You have the physical order of the records and you have the logical order (indexed) of the records. Usually we are not concerned with the physical order of the records but rather their logical order. Your question raises another question back to you, what, exactly, do you mean by "not at the end of the view"? Are you trying to place the record in some logical ordered position? Are you concerend on where it appears within a grid or some display control or report? If you can described your goal in more detail we can assist you in accomplishing that goal better.