6 Replies Latest reply on Jul 9, 2014 2:39 PM by pademo57

    Ranking Employees - Part 2



      Ranking Employees - Part 2


           Hi There,

           Finally clued in to what people have been trying to tell me with using relationships and global fields. However, now the problem is when I have a list of employees with rank of 1, when I try to display in my drop-down list it only shows the first one instead of the six people who have rank of 1.

           I also tried this with a separate drop-down for people with rank of 2 and the same thing occurs. 

           What is it that I am doing wrong?


        • 1. Re: Ranking Employees - Part 2

               Not being able to read all that has gone before leaves anyone reading your post with an extremely limited understanding of the design of your database. (And I respond to way too many posts to be able accurately remember such details...)

               But I would guess that you have specified the rank field as the second field value and are sorting on that value.

               That won't work in a field based value list. You'll need to think of a different approach to do what you want.

               If you are using FileMaker 13, you might consider using a selection portal located in a popover. In a selection portal you can sort your portal in ways that are impossible in a value list, and you use a button inside the portal row to select the value shown in that portal row. (The fields in the portal row can be turned into that button).

               If you are not using FileMaker 13, you might still use this method, but without the popover--either leaving the selection portal visible on your layout, inside a tab control or something that you pop up in it's own small window using the New Window script step.

          • 2. Re: Ranking Employees - Part 2

                 I think I need help in how to get help. Let me try this again. Attached is a jpeg file showing how I set up my table using global fields. I have set the relationship in my table occurences so when selecting an instructor it will select above the rank of student and below the rank of supervisor.

                 However, it only shows the first of each rank and not all of those indicated by the red boxes which show all the employees.

                 Not sure what I did wrong? Or is there a better way to do this?

            • 3. Re: Ranking Employees - Part 2

                   This does not modify my last suggestion.

                   Can you upload a screen shot showing the details of how you set up the value list?

              • 4. Re: Ranking Employees - Part 2

                     Ok, here is whatI have set up in the value list (shown in attachment).


                • 5. Re: Ranking Employees - Part 2

                       As I stated earlier, this use of the value list can't work as _fk_RankID doed not uniquely identify each employee in your table. Many employees will have the same value in this field.

                       From here, it looks like you need to specify _PKEmpID instead of _fk_RankID in this value list. And as long as the text in FullNameInit is unique for each employee, you can hide the first field and thus get an alphabetical list of "instructors" to appear in your conditional value list.

                  • 6. Re: Ranking Employees - Part 2

                         Thank you so much PhilModJunk,

                         That was it! I changed to the _PKEmpID and it is working wonderfully. I hope you never get tired of people singing your praises!