>I am trying to minimize the amount of data flow between our file server and a VFP 3.0b application. I have one-to-many releational database setup consisting of about 16 tables the parent being "client". If possible I would like to have the user input a client's SIN number at the workstation and only the one client record come across the line and also only the records relating to that sin from the other tables. Can this be done with fetch/cursorsetprop or does it happen automatically and I don't know it? I know in testing The relationship limits me to seeing only the neccessary records but in actual fact does hundreds of records travel across the line without purpose.
>
>Any advice would greatly be apprecieated.
>
>Thanks
>
>Scott k

What you are describing is client server. FoxPro native files are not client server. You have two options:

1) Install a C/S back end
2) Run an Automation Sever on the server and send your queries to it. The Automation Server will then return only the requested data. VFP 5.0 is capable of creating an Automation Server.