I've got some Company records that I am comparing to our current database (basically just for a deduping process).
All I am doing is a portal that looks up the postcode to match the new data which works fine.
I am using the below to find the number of matching characters.
New Data - Filemaker Community Limited
Old Data - Filemaker Ltd
cMatchedCharactCount = 10
Now the problem occurs in the portal, as it only calculates the result on the first portal record.
Is there something I can add so it calculates each portal result?
Some companies can have several other companies appear in my matching portal so would make the process quicker.