Newbie Questions

Re: 2 tables, multipe related records - how best to display in my form

Patrick Halstead — Tue, 26 Apr 2016 18:14:12 GMT

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.

2 tables, multipe related records - how best to display in my form

Brian Murphy — Mon, 18 Apr 2016 23:28:26 GMT

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! :)