Hello,

I have a database with two tables, "Student" and "teacher". On the "Student" layout, one of the fields is "Teacher's Name", which is a a value list using values from the "Teacher" table. I need to add another field "Teacher's Email" that is already on the "Teacher" layout. How do I do that without re-entering the information again?

I really appreciate your help.

Thanks,

Samuel

You need to create a relationship between the two tables. Relationship should read Teacher's Name (in Student Table) = Teacher's Name in "Teacher" table. You can then add Teacher's e-mail to your layout, and, as soon as teacher name is input, the e-mail will fill using current data from the "Teacher" table. The data will automatically update if the data in the Teacher table is changed.

Thank you fseipel and LaRetta for your help.

I did try what LaRetta suggested and it worked great. Thanks again!