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

K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top