need help with expression

[terry518]

Okay I have two forms gathering information. The first form gets the employee's last name, first name, ID num, and department. The second form gets the training information they've done and they are linked by the ID num. When they are entering the training information in the form they choose which employee it goes under by picking out the employee ID num from a combo box. The combo box also shows the first and last names beside the number when it drops down. The problem I have is that I would like to have a box off to the side showing the last and first name of the person that is picked to have the training go under. This is so that if you go through all the form entries you can see the persons name to and not just the ID number you've choosen.

Thanks
Terry

 

[Pat Hartman]

Base the form on a query that joins the main table to the table with the student information. That way, the student's name will be available from the form's recordsource. As soon as you choose a student ID, the name fields will populate automatically. This is the power of a relational database. Once you have normalized your tables so that the data is not duplicated, you use queries to bring it back together again