Jim,

>Acknowledging that DELETED records do cause trouble/confusion to many people, as well as real implementation problems, what about something along these lines...

>Let VFP, at the TABLE level, have an indicator telling the required handling of DELETED records. Default would be "as traditional" but other options would be to 'ignore totally' (as if they do NOT exist in there) or 'Recycle' (as your suggestion, implying igonre totally too), or ... (you name it - I'm sure there are other useful possibilities).

Well, this really sounds nice. Much of my wishes could be forfilled with the option. This solution seems to be even more comstructive than my ideas for:

-Optimizable filtered indexes: because if you set the indication to 'ignore totally' indexes would be scoped to non deleted records. This also would take away the reqiurement for filtered primary indexes (see active discussion with Jim B).

-A SET RECYCLE ON command, because it can be set at the table level. Each table could have it's own setting. Very static tables would not need this feature, Very dynamical could really benefit.

Of course i've got to rethink my wishes, but at first sight it seems great.

>Being at the table level would remove any possible conflict from program to program in apps.

>Just an idea

Thanks, for the thinking....

Walter,