>Yes, I'll try that, Tim
>
>Another problem was that bringing the records from the DBF into the datatable was taking too long.
>
>Naomi's link pointed me at the OPENQUERY function in SQL Server which allows me to execute a SQL query against a Linked Server that lets VFP use Rushmore to select a subset of the table almost as quickly as it does in VFP.
>
>Now I have some great choices.
>I can combine the data on the server with SQLCommand by using JOINS, or I can use your approach of relating the data in the dataset
>I'll try them both.
>
>Thanks again for your help, Tim
>
>
>
>>>Bill, if you have tables from both sources already in dot net DataTables it isn't that difficult to put them in a DataSet together and then add a relationship. Maybe I misunderstood that part. Depending on how you are getting your two DataTables, you could just modify that and add the first to a DataSet and then add the second retrieval into its own table but in the same DataSet. Then set a relation.
It sounds like that method might work well and Naomi does seem to know here SQL data stuff. Good luck.
Tim
Timothy Bryan