InfoPath Dev

 Sure - Patrick actually came up with a really cool method for this not too long ago - here's a YouTube link that might help you. http://www.youtube.com/watch?v=NRjRYtcR8Gw

Yes, qRules has a command called CopyTable which allows you to accomplish this. There's a sample here: http://www.infopathdev.com/files/folders/qrules/entry75348.aspx There's also free qRules training available here: http://www.infopathdev.com/files/folders/qrulestraining/default.aspx If the schema of the secondary data source and the ...

 No, not currently.  I assume I can use qRules to do that.  I'm very new and need some guidance.

 Thank you!

 I'm sorry - I've not seen this before. Can you attach your form under Options so I can reproduce this issue?

 I would try a tool to test the CAML query so you can verify the correct syntax needed - this one is the one I use: http://www.codeproject.com/Articles/458008/CAML-Query-Builder  EDITED: Looks like the link to the U2U builder is dead in the post above - here's a Stack Overflow thread that offers some alternates: ...

Can anyone please provide some assistance?  Really struggling with this and tried various things to no avail.

 Sorry, I mean It isn't work, but if I try to query an list it Works!. When I use this CAML in a list column it's Works, but when I use this <Where> to querying a promoted column as a condition in an InfoPath library it isn't Works.  

The mapping tool and command only work with the main data source at this point. Do you have a repeating table in your main data source that you are copying your data into?