Compare same field in linked records

[s_t_mac81]

Hi all,

I have two tables: Projects and Tasks. Each task has one or more municipalities. What I'd like to do is check if all the municipalities in each task associated with a particular project are the same. I initially thought I could do this with a rollup and ARRAYUNIQUE(values) and a comparison of the Municipality field with the rolled up field. As you can see below "Glenville, Rotterdam" is a match, but that is not what I am looking for. I only want a match if all the fields are exactly the same.

Any ideas on how to achieve this?

 

[TheTimeSavingCo]

Hmm, so only the second record matches, is that right?  Could you provide screenshots of how the data's set up in the original base so that I can try to recreate your setup and figure out a solution for you?  If you could provide an example base that'd be ideal

[s_t_mac81]

Thank you for the response. I realized the solution as I was typing out an explanation. I had some "yes" and some "no." I just needed to roll up that "yes", "no" field and reject any that had at least one "no." Thank you again.