If then reference

J

Joey041

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!
 
M

Madhivanan

Is this you want?

Select teachername from table where studentname='studentname'

Madhivanan
 
J

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.
Click to expand...

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]
 
Top