>>Ok, here's the deal. I have a form with a grid which holds data from a parameterized view. the view is lited in my DE and opens just fine when the form instantiates, but the base tables that the view is constructed from also open up, because I guess it needs to run the SQL on the tables to get the view definintion. The problem comes when I exit this form. The view closes as it should, but the base tables remain open. Is there a way to make these base tables close when the form is released without having to release them individually. I poked around for some time, but couldn't find a way to close tables except for selecting tables and issueing use to close. It would seem there should be a better way to do this.
>>
>>Thanks!!
>>
>>John.
>
>Are the base tables in the DE? If not, try adding them there. If AutoCloseTables is .T. they should close when the form is released.

Hi Rick,

This will work, but I guess I was looking looking for a way to do this that does not require me to add anything else into the DE except for the view. If that is not possible than I will do as you suggest which works fine! Thanks for responding.

John