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