Portal & Related Records

[blackwell]

I have a layout, let's call it the 'Student' layout, that has two portals. That layout displays records from the student table and the two portals display records from the courses and tutoring tables (see image A). What I am attemping to do is use information that is entered in the courses table via portal on the student layout, to create records in the tutoring table. The tutoring table uses a vaule-list based on the course id (see image A). The problem is, everytime I enter a course in the tutoring table, a new record is added to the courses table, with just the course id. I don't want that.

 

Please help!

 

Image A

 

Image B

[blackwell]

Here's the relationship:

[David Head]

Hmmm, very weird setup you have there.

 

What is a Banner ID?

 

I would have thought that to relate a student to a course, you would need an enrolment table. Otherwise, a 'course' is really a 'course done by one student'.

 

it doesn't make sense to try to create tutoring records in a portal when the table is two hops away. The tutoring table should be directly linked to the student.

[blackwell]

The banner id is an id used for student identification.

[blackwell]

Ok, here's the new relationship graph. I took your suggestion and created an enrollment table. Check it out:

 

Here's another problem:

No matter what I select the course id to be in the tutoring table, it still shows that same course name. I would like the course name to change when I change the course ID: