We have a school student/address database setup with about 500 students. Previously this was used by one or two secretaries, but now that we have FileMaker Server we would like teachers to be able to look up student addresses if needed. The catch is that we only want teachers to be able to see addresses for students in their own classes. FileMaker Server seems to have nothing built into it for permissions, and the permissions built into FileMaker don't seem appropriate for this either. It was suggested that we may need to make a form for each and every teacher and write FileMaker scripting that limits teachers to seeing their own form, but this seems like a long backwards way to accomplish the goal. Thank you. John J.

duplicate post

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB26&Number=52736&Forum=All_Forums&Words=jjobe&Match=Username&Searchpage=0&Limit=25&Old=allposts&Main=52736&Search=true#Post52736

There's a way to do this using conditional value lists. It isn't hard to do, although I don't recall it exactly right now. I think you create a value list using a field from a related file, and there is a "show related records only" option. The teacher starts from the Teachers file, which is related to the Students file. There is a pop-up or drop-down menu for the teacher to choose which student's address to get. The menu uses the value list, and only students who are related to that teacher will show up in the menu.