I have a courses table with a child table that contains the

required reading for that course. I also have a student table

that contains which course the student is currently taking with

a portal to the required reading table for the selected course.

What I'm trying to accomplish is a way to select which of the

required reading titles have been completed for the selected

course and student. Not sure if I'm approaching the correct

way, stumped :-(

Environment:

Hosted file on FileMaker Pro 11 Server with Mac/PC FileMaker Pro 10 clients.

Thank You

Anthony

Students-Courses.fp7.zip

I also have a student table

that contains which course the student is currently taking

Are you sure this is what you want - each student taking only one course?

Yes, Only one course per student.

Well, if you want to keep it extremely simple (and somewhat limited in reporting capabilities), you could try it this way:

Students-Courses1.zip

Otherwise you will need another table to record each book read by a student.

Otherwise you will need another table to record each book read by a student.

Yes, this was what I was trying to avoid.

Thank you so much for your solution, I think It was just what I was looking. I was over complicating it.

Thanks again

Anthony