Full Version: new to access
UtterAccess Forums > Microsoft® Access > Access Forms
cle819
i am working on a table for "employees". i have 3 tables: employee, department, manager. the relationship between department and manager is one to one (there is one manager per department). my question is... in the employee table i have a lookup table for the managerName. I am trying to make auto display the department according to what manager the employee is under. is that possible? If so how do I do it?
Thanks.
jmcwk
Welcome to UA Forums !
See if This helps sad.gif
cle819
code?! where am I suppose to do that?
jmcwk
Did you open up one of the Samples at the Bottom of the Link and examine it ? Open the Form(s) in design view, And Look for Event Procedure in the Forms Property Window as well as the Combo Property window by clicking the ... to the right of the Procedure this will open the VBA window whereas you can examine it.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.