School Database Pt2 - Adding records via portal

[Ollie Dog!]

This is another classic School Database setup - Tables: [color:blue]STUDENTS, ENROLLMENTS, CLASSES.

From the STUDENTS table, I've created a portal which contains student enrollment data. [color:red]Issue: I've been sucessful in setting up and displaying data from this relationship, however I also need the capability to [color:red]MODIFY records for that student contained in the portal.

[color:red]For example: from the STUDENTS table the user [registrar] should be able to [color:blue]ADD a new class to the students record. Currently, I can only [color:red]view those classes (via the PORTAL) which had been created in the ENROLLMENTS table. Any modification must be made through enrollments table directly, and not on the student record being viewed.

How can I add this [color:red]edit capability within the PORTAL - Please advise... :

Edited September 27, 2005 by Guest

[Sanjai]

In the relationship from student to enrollment, check the check boxes to allow creation of related records and when deleting a record in this field, delete records from the related table.

To allow deletion of protal rows, double click the portal in layout mode to go to portal setup window and check the check box to allow deletion of portal records. To allow modification of fields in the portal, select each field, right click on it, go to field format, select the check box to allow entry into the field.

[Ollie Dog!]

Dear Sanjai -

Thank you for your guidance - it works!