Can I use my combobox to pull data from another table and imput it to my Form?

[KenThompson]

I have a table(SupInfo) with SupervisorName & SupervisorID on it and a table(AssocInfo ) with AssociateName, AssociateID, & SupervisorID. I created a relationship between the two tables.

I have a drop down box full of supervisors(Sup ervisorName) and I need my form to recognize that once of one the supervisors is chosen, it should provide a list of associates(Asso ciateName) below. Is this possible?

[Seth Schrock]

It is very possible. See this link.