Hi!
I have a form at the moment with the fields 'student name' and 'course' (amongst others).
the field 'Student name' has a drop down menu linked to a table listing all the student names. On the same table is a column stating each students course.
How can I link this info together so that when you enter a student name on the form, their course appears in the 'course' field on the form?
I'm sure this is easily done but i'm stuck!
Cheers
Phil
I have a form at the moment with the fields 'student name' and 'course' (amongst others).
the field 'Student name' has a drop down menu linked to a table listing all the student names. On the same table is a column stating each students course.
How can I link this info together so that when you enter a student name on the form, their course appears in the 'course' field on the form?
I'm sure this is easily done but i'm stuck!
Cheers
Phil