Mark records with duplicate fields in a found set.

[b.hunt]

I'm looking for a solution to mark records which have duplicate fields in a found set. For example after constraining a found set of client records I would like a way to mark those, and any other records outside of the constrained set which share duplicate values in certain fields such as the same email addresses or phone numbers, and then return to the original found set.

Can anyone point me in the right direction here, thanks.

[rivet]

just did that so hot of the clipboard:

If ( GetNthRecord ( yourField ; Get ( RecordNumber )-1 ) = yourField ; 1 ; "" )

-constrain set

-sort by that field

-then in a new field do a 'replace field content' cal with the above

-then constrain set to the new field containing '1'

-delete found set.

[b.hunt]

Thanks for your reply, could you talk me through this a little more? Just to clarify I'm looking to mark any fields which are duplicate, so if i have a found set of 20 out of 50 records I need the script to mark those 20 found and mark any of the 30 outside the 20 found records if they share the same email address with anyone of the original 20 found records.

Hope that makes sense.

[comment]

I need the script to mark those 20 found and mark any of the 30 outside the 20 found records if they share the same email address with anyone of the original 20 found records.

Can you explain your purpose here? In general, marking records based on the found set is problematic since each user has their own found set.

Now, if I understand your question correctly, you could establish a found set of all records to be marked by:

1. Open a new window (in order to preserve the current found set in the original window);

2. Go to Related Record [ YourTable 2 ; Match found set ]

where YourTable 2 is another occurrence of your existing table, related to your existing table by matching email.

[rivet]

if I understand you correctly. see attached

tag-dups.mov