Hello again Walter

Your suggestion regarding setting a filter on !DELETED() is working out very well for me indeed. Thank You:)

I can now append into my files just as I could in the old days.

I am now thinking thinking about recycling deleted records again.

It occurs to me that, if I do this, I will have to do it with much more consideration than in the past, since any app I write now may get upsized to SQL Server and I now work entirely through views.

In the past I used a function I called BlankLock for this.

Basically all it did was attempt to find a deleted record. If it finds one it would blank the record and lock it.
If it couldnt find one it would insert a new record and lock it.

Since I am now doing everything via views I now am scratching my head wondering if it is going to be possible to recycle deleted records at all.

The function would first have to check that the view was based on a normal VFP table (if it isn't it just does an insert and returns)

If it is based on a VFP table, then it would have to find a deleted record in the base table and add it to the current view. Then it would have to blank it and lock it.

Can you see anything in the above that would stop attempting this?

Many Thanks

Mark