I've used this technique before. Create a calculation field in your student db. the calc "If(mentor="yes", student name, ""). Now create a mentor list in your value lists and point the list to this field. You should only see student mentors on the list, and if you change the mentor field to no, the student should come of the list automagically.

hope this helps

I have a database of students and some have volunteered to mentor incoming students. I have tried to create a script that, when run, will find all those where the mentor field is yes, and then erase the mentor list and fill it in with the found records. I can get it to find the mentors and open the value list window, but I can't figure out how to get the found records into the value list.

The other option I was considering was some how exporting the found records to another mentor DB and just using the name field as the entries in the value list.

Thanks in advance, qntgeek

quote:

---

Originally posted by WBlanchard:

You should only see student mentors on the list, and if you change the mentor field to no, the student should come of the list automagically.

hope this helps

---

Getting the students on the list works great but when I change the field to no it doesn't clear their name.

Right now i have the auto-enter calc of:

Case(Mentor = "Yes", First Name, Mentor = "No", "","")

and a validation of:

Case(Mentor = "Yes" and MentorCalc=First Name, 1, Mentor = "No" and MentorCalc = "", 1,0)

If you change mentor to no and try to change records the validation catches that it's not blank, but you have to manually erase the name, it won't do the auto enter again...

Dazed and confused, qntgeek

Bear with me!

It sounds complicated, but persevere and I think you