>I have an application with about 15 tables. To this point I have displayed data using browse windows, which works fine because I have been able to create temporary cursors and display the cursor with a browse statement. However, I am lost as how to do this with a grid on a form.
>
>The first problem is loading the cursor. The SQL statement opens the underlying base table. If another form has also opened that that base table you get the error...file in use. I just can't seem to get around the problem. I'm quite sure the solution is simple...and maybe that's why I'm missing it.
>
>Chuck

Use Grid.RecordSourcetype=1 and set in code Grid.Recordsource="mycursor". Also, put all tables you're going to use into Form.DataEnvironment and it will care of opening/closing them.