Hi,

I have 4 tables - People, Facilitators, Participants and Courses. The main table is People. People could be either Facilitators or Participants or both in many Courses. People and Participants are related by Client ID(primary key for People) and so is People and Facilitators. Participants(of a course i.e.) and Courses table are related by Course ID(primary key for Courses) and so are Facilitators and Courses.

From the People table I need to get information of all the Courses that a "Client" has either participated or facilitated. I thought of adding 2 fields to People, FacilitatorCourseID and ParticipantCourseID(the CourseID from Facilitators table and Participants table respectively, that relates them to the Courses table). These fields, I thought could be looked up from the Facilitators and Participants table, CourseID field. But the obvious problem is that this field can have only one CourseID, whereas a facilitator or participant could have more than one CourseID. So, how do I get records from Courses from the People Table using Client ID as the find criteria? I know I have to go through the Facilitators and Participants Tables, as People and courses are not directly related. I can't figure out how though!

Could anyone give me some advise/guidance please?

Thank you.

Prithvi

Thanks for viewing my question. I worked it out. Turned out to be simple.