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. Id 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 CANT BE MERGED into single one]
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 CANT BE MERGED into single one]
Last edited by a moderator: