value list based on relationship

[e3digital]

I have a database of teachers and other school services personnel. It is related to a database of school districts the teachers work in. In Teachers.fp5 I have a value list created from the records in Districts.fp5. It is displayed as checkboxes since a teacher can work in more than one district.

Many districts have more than one building and I need to indicate in Teachers.fp5 what buildings a teacher works in. I don't want to list all the buildings in all the districts for every teacher...Is there a way I can display in Teachers.fp5 only the buildings that exist in the districts they work in (indicated in the checkboxes)?

Thanks for your help.

Susan

[jasonwood]

search the forums for "conditional value list". There are many explanations of this. I just wrote one a few days ago I think.

[Ugo DI LUCA]

Hope I understand correctly your post.

In that case, I wouldn't use a value list. I would use portal filtering, creating a new file Buildings.fp5 file