InfoPath Dev

I have a drop-down that pulls venue information from a sharepoint list.  Currently it is filtered to only pull in venues where @ State = State (another field in my form).   This works fine. 

The problem is, in some areas, say Washington, DC, we may need a bigger radius than just state. 

So I tried adding more filter to it

Sharepoint State = Form Field State (the basic filter) or

Form Field State = "DC" and

SharePoint State = "DC" and

SharePoint State = "MD" and

SharePoint State = "VA"

But it still only uses the basic filter (State = State)

Any suggestions or workarounds?

There's a problem with your logic.  What you need is

FormFieldState = "DC" AND (SharePointState = "DC" OR SharePointState = "MD" OR SharePointState = "VA")

 But since AND has a higher precedence than OR, you can't just fix this by switching two of the ANDs with OR.  Your options are:

Change the OR part to be one expression:

FormFieldState = "DC" AND

SharePointState = "DC" OR SharePointState = "MD" OR SharePointState = "VA"

Or make it three separate filters

FormFieldState = "DC" AND

SharePointState = "DC"

 

FormFieldState = "DC" AND

SharePointState = "MD"

 

FormFieldState = "DC" AND

SharePointState = "VA"

That works great by itself, but if the form field does not equal DC, I need it to just match states (State = State).   When I add State = State at the end of the filter, it just uses that filter only.

Never mind I figured it out.  The State = State filter needs to be "or"'d at the end of the other ones.  It works great now.  Thanks.  I owe you a beer.