Sorting Titles in FileMaker
If anyone could help,
I am using FileMaker Pro 10 on Mac and have created a database for a movie collection. I have all the titles sorted by Format (DVD,Blu-Ray, etc.) then by Movie Title. That is all working out fine. The problem I am having is with titles that start with "A" and "The" they don't sort correctly and am trying to figure out to make it so that it passes over the first word either "A" or "The" and moves to the next word of the title (where it should be in the alphabet). I am not to fimilar with the program yet so any quick walkthrough on how to change this would be great. Thanks!