lookup question

[_samuel_]

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

[fseipel]

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.

[_samuel_]

Thank you fseipel and LaRetta for your help.

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