>Assuming that you want to use VFP as the third tier because of the speed of VFP and your familiarity with it, I suspect that you will meet disappointment with your plans.
>
Although I haven't used this technique yet, I can imagine an object that requeries and gets a desired set of records, then passes them to another object using FileToStr() and StrToFile().
FirstObject's Requery()
REQUERY("MyView")
This.FileString = FILETOSTR("MyView")
OtherObject.Requery
Calls FirstObject's Requery()
STRTOFILE(OtherObject.FileString,"MyView")
I assume this would be limited to small files < 64K.
On the update side one might gather up the changed or new records from OtherObject and return them to the FirstObject. That method would have to update or insert into the FirstObject's view.
Charlie