If then reference

[Guest]

Hello,

I am attempted to design a datebase so that a student's name will be
available from the drop down field and when that student is selected, I would
like their teacher's name to be populated based upon that selection.

Any ideas?

New to Acces but digging it!

 

[Madhivanan]

Is this you want?

Select teachername from table where studentname='studentname'

Madhivanan

 

[John Vinson]

Hello,

I am attempted to design a datebase so that a student's name will be
available from the drop down field and when that student is selected, I would
like their teacher's name to be populated based upon that selection.

Where are you getting the teacher's name from, and where are you
planning to store it - or do you just want to display it on the form?

John W. Vinson[MVP]