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

Image C (Relationship)

Edited March 14, 200817 yr by Guest

Charles, (good name BTW)

I think what your problem is, if I understand it correctly, is the order of the tutor table in your relationship diagram.

when you creat a new portal row it is creating the new record in the courses table becase that is the one that is first. You can test this by turning off allow creating of related records between the students and the courses tables.

Is the idea that you can add a tutoring reccomendation for a course that THAT student is taking? You can join the students table directly to the tutoring table, and still have your courses value list show the other related courses.

Charles

Edited March 14, 200817 yr by Guest