>>>>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?
This is probably where we are missing each other. This view was created in the view designer, and I am attempting to add the filter in the 'Filter' tab. Adding the above suggestion in the expression builder under filter gives the error.
Erik Moore
Clientelligence