>The staic recordsource can still be a cusor, right? Or do I have to use a table for the recordsource?
>
>Thanks for all you help.
>
>Gary
Yes, it still will be a cursor.
Form's load
create cursor with the needed structure
or
select * from ... where 1=0 into GridCursor
When we're changing cursomer:
zap in GridCursor
insert into GridCursor
select *..from where Customer = m.lnCustomer
This will work if you're using VFP tables. For SQL Server select into temp cursor and then zap and insert the same way as above.
If it's not broken, fix it until it is.
My Blog