InfoPath Dev

Hello, I have infopath2013 form having 2 multi value choice list. These choice list values coming from other list and having the same values. My requirement is that when user select any value from choice list 1, then the same option should be removed from choice 2 or disabled. The objective is to restrict user from selecting same value. If hide ...

Thanks, that worked a treat! :)

Here's a link that may help: https://support.office.com/en-us/article/filter-the-data-that-is-displayed-in-a-control-7c9471ed-46e6-40fc-93b6-8f25e5fa4deb 

 Can you point me to info about Xpath filters.. sounds like I will need to know more..

Wonderful news! So you know - the reason a very simple rule works here is because both lookups come from the same list. If they did not, you'd need to use an XPath filter.

 Hi Hilary, Thank you, it works now! Kenny

Actually, the first one also now includes the School Email - I'm not sure why you couldn't edit it? At any rate, give this a try. Save it locally, right click and select Design to open in design mode, then preview and see if my rule on the schools field works - I believe that in a case like this, where you have multiple lookups on the same ...

 Hi Hilary, I created a new data connection called schools-email-lookup1 which has both fields connected. I couldn't edit the first one. Hopefully this is what you need.. Many thanks for your help! Kenny

Your secondary data connection called schools-email-lookup needs to also include the email column from that list. Can you update your test form & re-attach? Also- when working with list forms, you often need to select "Show advanced view" on the field picker dialogs.

Hi Hilary, thanks for your reply, I have attached the file. probably best for me to see how you do it. Cheers Kenny