InfoPath Dev

{   // Get the default SQL command for the form.   var strOrigSQLCommand = XDocument.QueryAdapter.Command;   // Get the query node that you want to modify.   var querySupplier_T = XDocument.DOM.selectSingleNode(     "/dfs:myFields/dfs:queryFields/q:Supplier_T");   var queryRegion_T = ...

You say , "in the one I was using, it added "relate [ID] to [System]" after the select command for the second table", I'm not following...when you say "it" what exactly are you referring to?  Could you just post the amended code in its entirety so I can see what it is you mean?  I'm going through my ...

   Thank you for your continued assistance, I implemented the Rule you suggested but am still experiencing the same issue. I am begining to suspect this is occuring because the State drop-down field is a nested repeating table within the Region repeating table resulting in the current()/my:Region filter not operating as expected ...

First, thank you for your response...please forgive me for not clarifying as I did have the second as a repeating table, currently My Data Source looks like this:  Geocoding      Locations (Group - Not Repeating)           Regions (Group - ...

I’m sure my nomenclature is wrong but I will do my best to describe.  I understand how to accomplish cascading filters when you have two attributes within the same repeating group (ex. City/State) when you select the State you are only presented with Cities within that State.  Of course when you do this you end up with a repeating table ...