Trouble with sort order
I'm relatively new to Filemaker. I'm using Filemaker Pro 11 on Windows Vista.
I work for a university, and I am trying to create a database of our faculty members. Each faculty member may have multiple job titles. For example, I might have
Clark - Department Head, Professor
Adams - Professor
Graham - Associate Professor
To keep consistency in the titles, I have a separate table with all the job titles and their appropriate ranking, and then link the faculty to those titles with an intermediate table.
The problem comes when I try to sort the faculty in order of job ranking. If I sort by job rank and then by name, what I want to get is:
in that order, since Clark outranks Adams as the department head. What I get is:
I'm not totally sure what is happening, but it seems like Filemaker just ignores the department head title and sorts the professors alphabetically. It is only an issue with faculty members who have two or more job titles, but unfortunately we have quite a few of them (various department heads, deans, etc.), and some faculty have up to four titles. Is there a workaround for this? Am I going about it all wrong in the first place?
Thank you in advance for any help you can give me.