InfoPath Dev

It does, and it works.  Thanks.

I need to set a field with the result.  How do I accomplish this?  I know I'm missing something simple. 

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.

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.

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 ...

[quote user="Hilary Stoupa"]  Glad you got it figured out! [/quote]   Shniggens - 1 Hilary - 437   ; )

OK, that worked.  I actually had to "and" them, but the results were the same as the " | ".

not(my:MasterLaborPerson = (current()/following-sibling::my:RoomingTable | current()/preceding-sibling::my:RoomingTable)/my:Occupant1)  I basically replaced my fields with Jimmy's example.  Is there an alternative to " | "?

Well it works great in the client, but when I try to publish it to SharePoint, I get this error - '(current()/following-sibling::my:RoomingTable union current()/preceding-sibling::my:RoomingTable)/my:Occupant1' has an invalid token.   Any idea what might be causing that?

Well tell that super-genius I said THANK YOU!  This is brilliantly perfect.  Thanks to both of you.