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:




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


Running on:

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




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