2 Replies Latest reply on Mar 2, 2013 2:39 PM by JohnDennis

    Case sensitive data entry

    JohnDennis

      Title

      Case sensitive data entry

      Post

           Hi all, first post here! I have been using FileMaker for some time now, but obviously I'm still learning, so bear with me if I've missed something obvious here.

           I'm just wondering if there is a way to validate a text field so that only numbers and uppercase letters can be entered into it.

           The reason I ask is that I am creating a field where the text will be used to generate a barcode. However, the barcode font will only allow uppercase letters and numbers, so I need to restrict the field to only accept this kind of text.

           My other option is to investigate having a relationship set up with another table where a serial number is generated for the client, and have this serial number return the client's record when scanned. I would prefer not to have to do this, however, as it could be annoying to set up.

           Thanks in advance for your help!