AnsweredAssumed Answered

Problem with Finding Duplicate Records

Question asked by ericellis9 on Dec 19, 2016
Latest reply on Dec 21, 2016 by taylorsharpe

Hi there...

 

I am importing records into FMP from another source to find duplicates from that source.  The import script is attached.

 

Once the data is imported, I perform a find on a calculated field called C_Full_Name  (see also attached).

 

This is the strange behavior:

 

When I perform a duplicate find on the "C_Full_Name" field, I get duplicates.  For example, it tells me there is a duplicate for the name "John Daly" (see attached).

 

However, if I then search on the "C_Full_Name" field for "John Daly", it only finds one record, not the two I expected.

 

Any thoughts?

 

Here is my system info:

 

CLIENT INFO:

 

FMP 13 Ver 13.0v4 (11-13-2014)

 

Running on:

Multiple MAC Computers, all running OS X (Ver 10.8.5)

 

SERVER INFO:

 

FMP 13 Server (Admin Console version: 13.0v9 x64 (01-09-2015)

 

Running on: 

Mac mini (Late 2012)

OS: OS X (Ver 10.8.5)

Processor: 2.6 Ghz Intyel Core i7

Memory: 16GB 1600 MHz DDR3

Outcomes