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

Hello,

 

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:

Relationships.JPG

 

My fields:

Check Duplicate.JPG

 

Counter.JPG

 

Thank you!

-L

Outcomes