Oh, right....duuuhhhh....you knew what I meant, Bob :-D
>>Strange --- OK, here's what I did:
>>
>>SET DELETED OFF then opened the view ... shows 6 records, none deleted (4 of the base table records are deleted). Did not requery, though....
>>
>
>John... you may be thinking in reverse though...
>
>remember:
>
>SET DELETED OFF - SHOWS/PROCESS DELETED RECORDS
>
>SET DELETED ON - HIDES DELETED RECORDS
>
>BOb
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05