Changing to Title Case
I am using FMP 11 Advanced and I have a field that is now restricted as a Lookup field. However, before that happened, users would type information in the field that was all upper case, or all lower case, or some of both. I would like to change the existing data in that field so that it shows Title Case and everything is now consistent. How can I do that without scrolling through the 15,000 records and changing each one manually? Thanks!