1 Reply Latest reply on Mar 25, 2013 12:07 PM by philmodjunk

    Sorting Records by Relationship Value

    JonasArild

      Title

      Sorting Records by Relationship Value

      Post

      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".

      Example:

           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.

        • 1. Re: Sorting Records by Relationship Value
          philmodjunk

               Use a list view layout based on the join table: EmpQualRelate

               You can include any needed fields from the other two tables on this layout and you can find and sort records on this layout to get the list of employees qualified for PHP sorted by their ranking.

               A filtered portal or ExecuteSQL calculation field can also selectively display a list of records from the Join table filtered for a specific skill and sorted by a specific ranking.

               You'd need a new relationship to a different occurrence of the join table for the filtered portal to work.