Lookup and seearch

[astarbyfar]

Hi just wondering if anyone can help Im wanting to create a query that uses a drop down menu. E.g. If i have a table of teachers which i must pick one then the system will return a list of school children. Any links to releveant examples would be extremely useful