AnsweredAssumed Answered

FileMaker Pro

Question asked by mohansen on Feb 4, 2015
Latest reply on Feb 4, 2015 by Benjamin Fehr

Product

FileMaker Pro

Version

13.0 v5

Operating system version

windows 8.1

Description of the issue

My database consists of records. Every single record is suppose belong to only one unik person.
Therefore i have created a field called CPR. The CPR field is a number field with consists of 10 digits.
The 10 digits are unique because no person shares his/her digits with another person.

Steps to reproduce the problem

My wish is to have another field called check cpr. In this field i can put in the digits and then by a click button or another function it will calculate through every record to see if the person already exists in my database. Because i dont wont to have a person to figure in two or more records

Expected result

A message saying if the person already exist and another message saying if the person do not exist.

Outcomes