How to create a search field
I'm using Filemaker 11.
I have 2 tables: Student and Teacher.
In the Student form, I would like to create a field named "Teacher". I would like to be able to enter few letters in this field and to see in real time the name of the teachers that matches those letters.
Once the teacher is selected, I would like to have other fields to be automatically populated: Teacher.departement and Teacher.email.
Is it something that is feasable?
Thanks a lot! :)