"SELECT Id, NameFirst, NameLast
WHERE Status=? " ; "" ; "" ; "Teacher" )
Thanks for the answer but I still a little lost. Would I put this in a script? Or if I want it to be in a drop down list I'm not sure how to code it into the drop down.
Sorry to be such a newbie.
Sorry I should explain it a little better. In my Employee table I had these fields:
id (primary key)
Status (checkbox which has 3 values: Student, Teacher and Other)
I also have a Courses table and a join table j_Student_Courses
If I want to show a Drop Down or Pop-up on my Courses table where only the teachers show up, how do I add your Select statement to show only the teachers?
that's what I get for not fully reading the question.
You need to create a filtered Value List. In the parent table create a calculation field with the value Teacher text result...
Create a relationship using this field to the Status field in the Employee table. Then create a Value List using this relationship. Select Include only related values starting from: Courses (Parent Table).
Thanks for the answer and it is working well except for one little thing I tried to have only show values from the second field but instead it shows a ? question mark. Yet if I let it show the id from the first field it works fine (except that it shows the id along with the Teacher name.
Is there a way I can get it to only show the teacher name?
That's odd. Are you sure you are using the same relationship to display both values?
Hopefully this will help explain what I have done and maybe you can point out the error of my ways:
As shown above, Teacher_c is a calcuation field with the value "Teacher".
Then I created a pop-up menu using values I created called Teacher Only
I used a 2nd TO from Employee and called it Employee_Teacher. Then for the value list I specified the id from Employee_Teacher and in the second field I used c_Init_FullName (a calculated field of Initials, First and Last name.
What I then get is shown above. When I select ONLY show values from the second field I get:
So what have I done wrong?
Is the field in Employee - c_Init_FullName Indexed?
Well this is REALLY embarrassing. The field c_Init_FullName is a calculation field but it was set to show a number field result instead of a text field result.
Thanks PSI for all your help and next time I will definitely double-check the results.
No problem - it's good when its a simple fix.