Case sensitive data entry
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!