InfoPath Dev

I need help find a way to loop through two repeating tables to make sure that if the same person is selected from a drop down box that the combined numbers do not equal more then 100%. See attachment pic for a visual

I'm attaching a sample with validation rules for this. Save the file locally, right click and select design. Preview and in the first column enter the same text for one or more rows in the tables. Enter whole numbers in the second column - when they get above 100 for the same "person" you'll see the validation rules fire. :)

Hilary, Thank you so much for the response, it worked perfectly. I have been reading your solutions online for many years and its really nice of you to solve one for me. Thank you very much.