>What do I need to set to see the deleted records in a table?
>(I already set the "set deleted to" OFF but it's not enough.)
>
>thanks
SET DELETED OFF
BROWSE
is enough. Please note that if you use forms, each form uses a private datasession; that means that SET DELETED may be ON for one form and OFF for another.
In the BROWSE window, you can press Ctrl-T to delete or un-delete a record. This should make it clear how a deleted record is supposed to look.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)