InfoPath Dev

I think you'll have to manually create this expression - if I get a chance later today, I'll try to put together a sample.

That would be much appreciated, Hilary.  Thanks. 

There may be a clever XPath-y way to do this, but I'm not seeing it - I'm forwarding to Jimmy in case he knows how to do this.

Oh yeah, Jimmy certainly did know how to do this (he's like a XPath super-genius). I'm attaching his sample form, check out the expressions he used for his filters on his drop downs!

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

Well it works great in the client, but when I try to publish it to SharePoint, I get this error -

What is your expression in the filter? It sounds like an issue with the "|" operator.

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 " | "?

I think you could replace with multiple expressions separated with "or" - you'll want to test this, of course, and verify it works in client prior to trying in browser.

not(my:MasterLaborPerson = current()/preceding-sibling::my:RoomingTable/my:Occupant1)

OR

not(my:MasterLaborPerson = current()/following-sibling::my:RoomingTable/my:Occupant1)

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

Yes, "and" not "or" - sorry about that. Glad you got it figured out!

Hilary Stoupa:

 Glad you got it figured out!

Shniggens - 1

Hilary - 437

; )