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?
Also, I want to copy records that the user selects from the remote view to the table. I am doing:
get criteria for selected records
select table
append from dbf('view') for criteria
Is there a more direct method? I am used to using
but this isn't supported in FP.
Rick Fitch
ATL Ultrasound
Bothell, WA