Using Subforms with Main Form

[dwjz07]

Hi. I have an employees main form that has various subforms attached. I have these forms related by employee id. The subforms are based on employee equipment info, i.e., hardware, software, security, etc. How do I populate the information for an employee based on the particular subforms. For example, I want to be able to see an employee info and all the equipment associated with the employee. Also, if it is necessary to re-import the employee information from an excel query, will the employee information populate to the existing equipment info for each employee? Thank you for the assistance.