Sorting Records by Relationship Value
Hello, this is my first post.
I have a table (Employees) that contains some employees.
Another table (Qualifications) contains some qualifications.
The third table (EmpQualRelate) relates the two tables mentioned above, but also includes a "ranking value".
John Doe, has been related to the qualification "PHP" vith the ranking "3", and "HTML" vith the ranking "1".
Jane Doe, has been related to the qualification "PHP" vith the ranking "2", and "jQuery" vith the ranking "4".
I have a layout for Employees records, containing a Portal with the EmpQualRelate records. Everything working nice and dandy.
My problem is: I want (read: need) to be able to sort the Employees record, by Qualification Ranking, ie. "PHP" ranking or "HTML" ranking or whatever is needed in the current situation.
I must also provide this option in a userfriendly manner, and all 3 tables will be constantly updated.
I used to keep al the data in the Employees table, as PHP ranking, HTML ranking etc. but this is no longer possible, as the number of Qualifications is rapidly growing out of hand.
Help is very much appreciated.