>>>I have a one-to-many view for which I would to give a filter for !deleted() in one table, but not the other. In the view builder (or otherwise), how do I reference one table or the other when giving a filter "deleted() = .F." ?
>>>
>>>Erik
>>
>>Try: WHERE !DELETED("Table1")
>>
>>Ed
>
>this gives "Variable 'table1' not found" (where table one is the name of my table).

I tested it and it works fine. Can you give us the full syntax of the SQL you are using?