I will try to, as simply as possible describe what I am trying to do. Please let me know if it is possible and if so, how.

- Within an application I have 3 forms.  Schools, Teachers, and Events.

- The School form has a field called Schools.  Schools is a single line entry field.

- The Teachers form has two fields called Teachers and Schools. The Teachers field is a single line entry field and the Schools field is a lookup field that references the Schools field in the Schools form.

- The Events database has 3 fields. The first entry field is a Single line entry field called Event.  The second field is School which is a lookup field referencing the School field in the School form. The third field is Teacher, which references the Teacher field in the Teacher form.

In the Events database, when someone is entering a teacher name into the Teacher field, based on the School name that has already been entered in the Events database for that record, I would like the dropdown to only list the teacher names from the Teacher form list that have the same School name in the Teachers form as the school name entered on the Events form.

I hope this makes sense. I suspect it can be done with a Deluge Script but I can figure out exactly how.

Thanks.