Forum Discussion

1 Reply

  • I'm sure that there is a script solution, but for a native solution I would set up a table with and create text key field.

    Then in your details table where the potential dups are, create a formula text field which concatenates the fields which define uniqueness.   I'm, not sure from your post if that is one field like an email address or the combination of a few fields. 

    Like List("-", [first name],[last name], [Phone])

    Then make a summary field report on that field and then copy the report to the Uniquer table you just created.

    Then make a relationship between the two tables and make a summary minimum field of the [Record ID#].  Then look that up down to the  details table.

    The non dups will be the detail records where the [Record ID#] <> Minimum Record ID# for unique value]