Title
Ranking Employees - Part 2
Post
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?
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.