Jump to content
Xtreme .Net Talk

Recommended Posts

Posted (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 by bob12345

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...