E
Eric IsWhoIAm
I have three tables: Courses (Key is Autonumber Course Number, also have
Text Course Name); Instructors (similar fields); and Courses and Instructors
(have a combination of the four fields).
Currently, if I manually select the course from the drop-down box, the
Course Number, and the same with the Instructor fields, then I can save the
record. If the Course Number doesn't match the Course Name, though, I'm out
of luck.
What I really want is, when I choose the Course Name in my Courses and
Instructors combo box on the from I made for it, for Access to do the
following:
--> Look in the Courses table.
--> Find the Course Name in the Courses table that corresponds to the Course
Name I chose in the Courses and Instructors form's combo box.
--> Find the matching Course Number that corresponds to the Course Name in
that
table.
--> Fill in the Course Number (in the Courses and Instructors form or table)
with the Course Number it found in the previous step.
So, I know how to break down the procedure I want it to do, but I don't know
how to tell Access to do this.
Please, anybody: Can you help me to translate these instructions into a
procedure that Access will understand?
Thanks,
Eric
Text Course Name); Instructors (similar fields); and Courses and Instructors
(have a combination of the four fields).
Currently, if I manually select the course from the drop-down box, the
Course Number, and the same with the Instructor fields, then I can save the
record. If the Course Number doesn't match the Course Name, though, I'm out
of luck.
What I really want is, when I choose the Course Name in my Courses and
Instructors combo box on the from I made for it, for Access to do the
following:
--> Look in the Courses table.
--> Find the Course Name in the Courses table that corresponds to the Course
Name I chose in the Courses and Instructors form's combo box.
--> Find the matching Course Number that corresponds to the Course Name in
that
table.
--> Fill in the Course Number (in the Courses and Instructors form or table)
with the Course Number it found in the previous step.
So, I know how to break down the procedure I want it to do, but I don't know
how to tell Access to do this.
Please, anybody: Can you help me to translate these instructions into a
procedure that Access will understand?
Thanks,
Eric