I am new to using Filemaker pro.
I'm creating a database in regards to a booking and invoicing system.
How do I validate a Forename or Surname field, so that
a) it changes the first letter to a capital automatically (i understand it uses proper or something?)
b) ensure that only letters between a-z are entered? When i tick the range box and enter between A and Z, the custom error message is displayed even when the letters are between a-z for example, "Daniel"
Thanks in advance,