bob12345 Posted September 7, 2003 Posted September 7, 2003 (edited) 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] Edited September 7, 2003 by bob12345 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.