Select from a combo box...

[Davers]

Hi everyone, this is my first post to the Access group....I'm very new to Access...I have 2 tables, 1 is Employee information, the second is Department information. On my "Add an Employee" form, I'd like to be able to choose the department from a combo box, and have the Manager of that department automatically pop up in the Manager box. I'm not quite sure how to do that. The Deparment table houses that information. Can someone explain how to do that in very simple terms... I have a "very basic" understanding of Access...

Thanks,

Dave M.

 

[bat17]

If the 2 table are joined in a query and the query used as the record source for the Form then it should populate itself automaticaly.
You should not be storing the Managers name in the employee table only the id of the department.

HTH

Peter

 

[Davers]

Thanks for the quick response! It's starting to ring a bell now. I've actually created a few databases in the past...(about 5 years), hopefully this will start making more sense the further I go!

Thanks again,

Dave M.