InfoPath Dev

 Hi - I have a from with 2 drop-downs that is filtered based on the selection of the first drop-down and data in my SP list. I want to further filter the data based on a Boolean field in the SP list. I can't figure out the logic to filter it based on a second criteria.

The first drop-down (Field Code) sets the values of the second drop-down (Field Contracts) but I only want to see the Field Contracts that are not Deactivated based on the Boolean field in the SP list.

 Any ideas on how to add a second filter to a drop-down? I tried adding it to the Field Code and Field Contracts field but it didn't work so I'm sure I'm not getting the syntax or order of operations correct.

Thanks in advance for your time.

 Hi there,

 How about you set a filter on the second drop-down(Field Contracts) to only filter Field Contracts that are not Deactivated.

Steps to add a filter on the Field Contracts drop down:

1) Select Fields Contracts drop down->Right Click->Select Drop-down List Box Properties

2) Click on the xPath for Entries

3) Click->Filter Data->Add

4) Select Deactivated is equal to TRUE 

Please see the attached screen shot.

Hope this helps!

Kind Regards,

Reema Daga
Qdabra® Software / InfoPathDev.com / FormsQuo / 425 999 4597 direct

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