i am setting up a database to keep track of my contacts. I sell software to schools. I want to set up a form that will let me enter district, school, contact's name by chosing from lists. (to avoid typos) To keep the lists from being very long, I would like to pick the district, then see only schools in that district; pick the school, then see only people at that school.

Can someone tell me how to do this?

This article will show you how to do what you want.

http://support.microsoft.com/support/kb/articles/Q209/5/76.ASP?LN=EN-US&SD=gn&FR=0&qry=q209576&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000