>Jess: Sorry but I'm still very new in this stuff. Could you be more specific as to how to do what you sugested?
>Thank you for your time.
>Ulises
Instead of using SELECT statement to create a cursor i.e. Select * From Table1 Into Cursor TempTable, in the load event of the form, do this:
CREATE CURSOR temptable ( name C(35), code C(10) )
You have the option to do indexing in the Init event if needed.
Create a method in the form to populate the cursor with either of the following:
SELECT temptable
ZAP
APPEND FROM your_source_table
OR
SELECT your_source_table
SCAN
SCATTER MEMVAR
INSERT INTO temptable FROM MEMVAR
ENDSCAN
Set the Grid's RecordSourceType to 6 or 2.
Other options:
1. You may want to use Local/Remote View instead of Cursor
and
2. Directly manipulate the tables by way of establishing relationship in the DE or making use of the Grid's LinkMaster, ChildOrder, RelationExpr properties.
Your choice!
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."