Hi Randy,

I would have the table order by an index key (primary key, perhaps) that are incremented by 100's or 1000's, depending on your needs. Then if user wants to add a record you just need to append to the bottom of the table (doesn't matter where the record physically goes). Then assign a key/index value that would be between the key/index values of the two records in question then refresh the form.

Just off the top of my head. Hope it helps.

Aloha,

James
>Hi. I am doing an invoicing program and my end-users want to add a row in the middle of the grid.
>I considered this:
>1. Copy the rest of the records in the dbf to an array
>2. Delete those same records from the dbf
>3. Append a blank record
>4. Bring the records back in from the array
>Of course, user would have to have exclusive use of the file.
>
>Q; is there an easier method? If not, what commands would I use to copy to / append records from an array?
>
>Thanks, Randy