InfoPath Dev

I have a repeating table that I want to conditionally display rows based on the results from another repeating table.  For Instance in the repeating table to be displayed I have Account Number and Sales Plant.  Based on the restricting repeating table the repeating table to be displayed should only show the two records  marked in bold lettering.  I've set up conditional formatting rule to hide records in Table A where Account Number and Sales Plant are not equal to Account Number and Sales Plant in Table B, but it doesn't appear to be working as expected.  I guess the question is...is this even possible or is there another to only display the records that match?  Table A and Table B use separate data connections that are queried then I'm comparing the results from Table A to Table B to determine which records to be displayed.

Sample - Repeating table to be displayed (Table A)

Account Number         Sales Plant

1234                          Georgia

4567                           Texas

1111                           Louisiana

8888                          Illinois

Sample - Repeating table used to restrict records in the above table (Table B)

Account Number       Sales Plant

8910                          Florida

4567                          Texas

1111                          Louisiana

Hello Sproctor722,

Thank you for your question. In regards to a resolution you have several options.

1. You could use a filter on the repeating row in Table A that uses the "If All occurance of 'AccountNumber" from table B != AccontNumber TableA then hide.

2. You could perform a filtered query in order to only return rows of data from table B.  In this instance you would want to use a web service query. Is your data coming from sharepoint lists, lists created in another view, or from a data base?

Let me know if you need more details.

Thanks,

Bre 

Bre Huston | Project Manager

Qdabra® Software / InfoPathDev.com / FormsQuo /  877.544.2389 main / 425.318.7843 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

The data from both Table A and Table B are from SharePoint lists. 

Both list are secondary data sources so I don't have the option to select All Occurences.