Reply to comment
The easiest way to find places where the same value is used in the same field across multiple records is to use a summary report. To do this, click the name of the table you are interested in finding duplicate field values for and select Create a new Report. Within the Report type section, select Summary. Now set the view properties to the following:
- Group Summary By: set this to the field you are interested in identifying duplicate entries for.
- Columns to Display: leave the default value, which should contain "# of <what track>" where the <what track> will be filled in with the noun used to represent the types of items you track in that table.
- Sorting: select the "Custom sorting/grouping" and sort by "# of <what track>". Also select the "from high to low" in the order dropdown, which will ensure that the field values that have multiple records will show up at the top of the list.
- Filtering: leave this set to default, which is to show all of the items you are tracking.
When you "Display" this report, you will be presented with a table that has two columns: the field values in the first column and the number of times that field's value has been entered across all records. At this point you can click on the field values to get the list of all the specific records that have that specific field value.