Rule # 1: Never make an application where the record number is important, use index tags instead.
Rule # 2: If the record number is important, rethink your design and see rule # 1.
Rule # 3: There are NO exceptions to these rules.

>ok Sorted this.
>It appears that if the table has any index file associated (even though you have not Set Order to) , it always appends the row
>If all Indexes are removed from the table, it works fine
>
>
>>Hi.
>>I have a small basic DBF with a few fields and I want to insert a row
>>I position myself on the 3rd row OF 10
>>No indexes are on
>>
>>INSERT BLANK BEFORE
>>
>>but it appends a row at the end (i.e. 11th record instead of being the 2nd record)
>>I know I have done this in the past , but cant get it to work today.
>>What am I missing ?
>>
>>Tia
>>Gerard