How to make a list and or subform for multiple entries into a reco

[KE]

I want to make an ACCESS database listing 30 American Heart Association
Instructors.

Some are instructors in more than one AHA course.

I have a table with all of the instructors and their demographic data.

I have a table which lists each course by date that it was offered, type of
course, etc.

I would like to be able to insert the list of instructors who taught during
a particular course. I would like to be able to do this by selecting from a
list. I would also like to be able to link these tables/queries somehow so
that I can make a query that shows what classes each instructor was invlolved
with, in a separate report that can be individualized by instructor.

I have to make a report (or query) that updates the instructor file (from
the course file) each time they participate in a course.

I would like this report to just self-update when the instructor is added to
a course date.

 

[[MVP] S.Clark]

That's a tall order.

Where are you having trouble? Where would you like to start?

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html