bob12345

I have parent table (Clients) in 1 MDB and child table (Orders, having Date field) in another MDB. I need to select only Clients which have Orders in certain Date, and their Orders too (put them into DataSet with Relationship). How can I do this with 2 MDB files? Connections and Adapters can point only single file. I'd be glad to do this with single SELECT statement. Actually I can fill relational DataSet with all Clients and only Orders of specified date. But in this case I have Clients rows with empty Order rows. I need only Clients who has non-empty Order entries. [These 2 MDB files CAN'T BE MERGED into single one]

No, it's defined not by me. Anyway, I've solved the problem. 2 adapters fill single dataset.

2 MDB files: 1st has Clients table ClientID and ClientName fields; 2nd has Orders table with OrderDate and ClientID fields and other. According to entered Date I need to display in 1st DataGrid ClientName and in 2nd DataGrid order(s) detials of same Client. So, I need 2 connections and 2 DataSets for each connection: I fill 1st DataSet with orders for specified date, having ClientID in it. Now, how do I select into 2nd DataSet names of appropriate clients from Clients table from another file (connection/adapter) basing on CleintID? How do I build "Select" statement based on data in anoher DataSet? VB.NET please.