Hello,

How would I solve this issue? I am working on a college registration
database in 8.5. There is a Teacher table and a Course table. Each
course can have a Teacher and an optional Co-Teacher, both of which
come from the Teacher table.

I need a portal/relationship where I can display all of the Courses
that a teacher has Taught or Co-Taught.

I believe this is probably simple and just involves a slightly more
complex relationship.

Any brilliant ideas?

Darren

Create a calculated field in the Course table named
Instructors = Teacher & "P" & CoTeacher
where P is a carriage return. Relate to THAT field.

G

On Feb 13, 6:10 am, "Darren" <darrenburgess1... (AT) gmail (DOT) com> wrote:

Create a third relationship for this purpose that simply displays all
classes for a teacher regardless of whether they were teaching or
co-teaching.

Darren wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

So what would this relationship look like?

I have a teacher table with a TeacherID and a course table with
TeacherID and CoTeacherID

I thought I could do this:

teacher:TeacherID = course:TeacherID AND teacher:teacherID =
course:CoTeacherID

but I don't think that will work.

How would you structure the third relationship?

Thank you.
Darren

On Feb 13, 11:45 am, Howard Schlossberg
<how... (AT) antispahm (DOT) fmprosolutions.com> wrote:

I would go with what Grip has already replied. Create a stored/indexed
calc field in Courses that includes both IDs separated by a return
character. Create your third relationship from The teacherID in the
Teachers table to this new calc field in Courses.

Darren wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

In article <12t4fdqr2b6cc76 (AT) corp (DOT) supernews.com>,
Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

You can do a many-to-many, courses to teachers. That requires an
intermediate join table. Call the Join table Course_Teacher.
Course_Teacher will have fields kfCourseID and kfTeacherID, as well as
other fields as needed.

Course::kpCourseID = Course_Teacher::kfCourseID
Teacher::kpTeacherID = Course_Teacher::kfTeacherID

Now you can have one portal in a layout of Course showing Course_Teacher
and the downstream teacher info, and conversely one portal in a Teacher
layout showing Course_Teacher and downstream Course info.

Course_Teacher could contain a field to show ther teacher assigned as
lead teacher, co-teacher, etc.

--
For email, change <fake> to <earthlink>
Bill Collins