>
records from the other tables getting children to any of the OWNERS records. (If I were doing this in VFP I would be using 'IN (SUBQUERY)' to select the child records. Not sure about MySQL.)

You are right about subquerys in Mysql, at the present, that feature is not yet avail.

>Actually now that I think about this, I realize I don't even have to change my current approach. Just keep the cursor of primary keys and retrieve one OWNERS record and associated children at a time. I assume that the SQL connection and retrieval for these very small sets would be so fast that the user would not notice. In fact I realize further that this approach would be much more appropriate for the occasional dial-up connection than downloading 100's and possibly 1000's of records at a time. "Small is Beautiful."

That is the main point of a client server based app, get as few records to the local machine has possible, then select 1 or more entire records (whatever you need to edit) and when you are finsihed put back just the changed records. Its different than a traditional VFP - approach, but when you start coding that that way, data just seems to fly.

>Thanks, again.
>
>Peter
>
P.S.
> One last thing: are either of you using a commercial framework with this approach?

Not myself, I have not found yet a commercial framwork which connects to Mysql. But the basis of the article, was the starting of a non commercial framework for making the connections work, and speeding up the writing time. What I ended up doing was putting all the funcitons which I use normally in to save, and edit / delete sql records right in my base class of my own form class, That way whenever I need to get a fresh record,I just call the class and its always there.
Bob Lee