>>You don't need in this relationships. Actually, the code snippet should look like this:
>>*** move record pointer in clients tables (nav button or combo selection)
>>nId=clients.id
>>Select * From Trips Into Cursor curTrip Where Trips.clientid=nId
>
>Ok, that makes sense.
>
>>This is simplified code, in real situation you better CREATE CURSOR first, e.g. in Form.Init event and just repopulate it when clients pointer moved.
>
>I hate to sound like a two-year-old, but, "Why?" Is there a reason that it's better to create the cursor first instead of just letting the SQL create it?
>
>Thanks,
>
>-Michelle
There is known grids problem. They hate to see their cursors to be bluntly overridden. It can be accomodated, but if you have small cursor, then it's reasonable not to override it. Your code may look like:
nId=Clients.id
IF NOT USED("curtrip")
CREATE CURSOR curtrip (.....)
Thisform.Grid1.Recordsource="curtrip"
ENDIF
Select curtrip
set safety off
ZAP
set safety on
Select ....From Trips Into Array Myarray Where Trips.ClientId=nId
Insert Into Curtrip From Array myarray
Thisform.Grid1.Refresh
Edward Pikman
Independent Consultant