2 Replies Latest reply on Feb 4, 2015 8:15 AM by Benjamin Fehr

    FileMaker Pro

    mohansen

      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.