>>I have a form with 2 tables (one remote view and one table, both in the database and data environment), 2 pages on a pageform, a grid on each page (one for each table). With AutoOpenTables .t., I find that the view and the table are opened and another instance of the table (alias "C") which is being accessed when I select the second grid.
>>If I turn off AutoOpenTables and use the tables in the form init method, the second grid accesses the table properly without the extra instance. ????? Any ideas why this extra instane appears?
>>
>
>As for the second instance of the table, is it possible you may have used a grid builder and now have a 2nd instance of the table in the DE? This happens to me frequently. Also, if you are not using a private DataSession, you are opening tables/views in a default DS where other tables may already be open.
>I found the cause of the second instance of the table. I had the recordsource type set to [table]. I changed it to [alias] and now it uses the table which is already open.
Thanks