>As I do a DEBUG, I notice
>the SET("DELETED") value changes, thus explaining
>technincally why it is showing deleted records,
>but why is this happening? I have no code that I
>know of that would do this.
>
If I may answer this portion only, there are 31 SET variables that are scoped to the current data session. That means that were you previously in the habit of setting all of your SET variables to what you wanted in your applications INITIALIZATION phase and forgetting them. Sorry! You can't get away with that anymore in VFP 3.0. Unless of course, you do everything in the default data session. Should you start up a form with its own Private Data Session, 31 SET variables get returned to there default condition. SET DELETED is one of these. I'm going to list them all in a new thread named SCOPED SET VARIABLES in this topic.