>I think that makes sense. However, I have very little experience with parameterized views and am wondering how I'm going to set up this view to change from all clients, to clients with rows in the emergency visit table to clients with rows in the legal activity table and back to clients. Also, I'm assuming I can treat the view just like the client table in my database and set persistant relationships so the other pages work so conveniently...
>
>
>>Diana,
>>
>>Filters and grids basically do not get along with each other very well. Parameterized views on the other hand will give you back the speed you've come to expect from FoxPro. Others have used SET KEY but I just find views to be so much easier to use.
>>

A simple select statement would yield the results you want just because of the way SQL works. Ie, if there are no records in the er table, a simple join would only give you the clients with er visits.


HTH

Wayne