I somewhat agree with you here, Cy. Don't use the View. A Fox2x table is better than using the ODBC driver. However, I prefer to use the VFP OLE DB Provider and having it do the query.

Send a hello to Kathy for me.


>
>Frankly, I would go the other way and pass the parameters that are needed by crystal from VFP using a selecting/parameter screen inside of VFP. As a matter of fact, you can't (unless something has changed) use a parameterized view via ODBC. If you are trying to do everything from Crystal, then you would likely have to do your own filtering after you get the data from the view. However, I have found that VFP is better at querying, so it's better to create a table for crystal from in VFP and then let crystal use that.