AnsweredAssumed Answered

Trouble with sort order

Question asked by wonderbike on Nov 1, 2010
Latest reply on Nov 4, 2010 by wonderbike

Title

Trouble with sort order

Post

Hi,

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:

Clark

Adams

Graham

in that order, since Clark outranks Adams as the department head. What I get is:

Adams

Clark

Graham

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.

MRH

Outcomes