InfoPath Dev

 Hi there,

I have a database filter question.  I am using InfoPath 2013 and Access 2013. 

I have 2 tables.  First table "House 279" (has the ID field) that is also referenced in the Second Table.  Second Table "Occupant" has 3 items (with Master ID) referenced to that 'house'.

How best can I filter and auto-populate my InfoPath form to show each of these occupants with their relevant fields? 

Thanks for any suggestions! :) 

Hello Brian and thank you for your patience,

Unfortunately, the out-of-box InfoPath never supported parameterized SQL querying and that has always been a bit of an issue.

We have provided two gap-filling solutions over the years - qRules has a ModifySQL command in it and our DBXL Web service support parameterized querying.

Both can be found under products on qdabra (dot) com.

Sorry there is no out-of-box.