AnsweredAssumed Answered

Finding Duplicate Values with Self Joing Relationships

Question asked by lindseym on Nov 29, 2017
Latest reply on Nov 29, 2017 by lindseym



What I am trying to do:

I want to create a field that shows "Duplicate" when entries have the same field entry (Comments). Does the counter column just create a unique serial number for each entry? If so, I don't need them to be the same number.


What I want.JPG


What I get:

Not that . I get a serial number, and "Duplicate" even if there is no duplicateView.JPG



I am using 14.0.6. I followed these instructions as best I could, but I do struggle with relationships:

Finding duplicate values using a self-join relationship


My edit layout:

Edit Layout.JPG


My Relationships:



My fields:

Check Duplicate.JPG




Thank you!