Filter Duplicate Values from a Data Connected Repeating Table?

I have a repeating table with 5 columns that accesses 1 field of a SharePoint List Data Connection. Users will potentially repeat this table 5 times or more. Thus, I would like to prevent them from making the same selection twice.

I was going to follow this thread to create data validation if a user were to make the same selection twice:
http://www.infopathdev.com/forums/t/10670.aspx

But I was wondering if you could Filter the SP list so that after a user makes one selection it would remove that value from being able to be selected again? If so, how would I go about this?
LVL 1
-PolakAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

-PolakAuthor Commented:
I believe I found a solution by creating the following filters on the secondary data connection "MissionPartners" in EACH of the 5 repeating fields in my repeating table using the not() function.

Please see the below image to assist in understanding:
snipAdditional clarification here:
http://www.infopathdev.com/forums/p/16059/56727.aspx#56727
While this is a bit cumbersome and takes a while to create with 5 repeating fields, it works. If an expert can confirm that this is the best way to go about the solution I will award points.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
InfoPath

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.