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.
Here is my system info:
FMP 13 Ver 13.0v4 (11-13-2014)
Multiple MAC Computers, all running OS X (Ver 10.8.5)
FMP 13 Server (Admin Console version: 13.0v9 x64 (01-09-2015)
Mac mini (Late 2012)
OS: OS X (Ver 10.8.5)
Processor: 2.6 Ghz Intyel Core i7
Memory: 16GB 1600 MHz DDR3