>>Tested this and you're right. If you index on "f1" in Mike's code and then run it, the record gets place at the physical end of file, or, basically where the index would show it. That's pretty unusual behavior.
>
>Yep, it's exactly what I did. Really strange. Looks like we can insert in the middle of the table only if the table doesn't have indexes at all.
>Should test it more throughly to confirm this assumption, though.
>>
>>
>>>Seems to work only if there are no indexes at all.
>>>Try add index and set order to before inserting...


From FPW 2.6 Help

If you issue INSERT BLANK, an editing window isn't displayed and the new blank record is placed immediately after the current record. If the table/.DBF has an index tag or index, the new blank record is placed at the end of the table/.DBF.