Hi Alex,

The area of the application that is in question pertains to students class assignments and grade records. Each student has a master record and many different children records such as a profile record (showing demogragpic info), address record, phone record and a grade record (each type of record in its own table obviously).

The student profile record contains, amoung other things, a foreign key to the class to which the student is assigned.

There is also a class master file with a child record for each session (seperate dates) of the class. The class master record contains the type of class, location, day of week that it meets, etc. The class session record (child of class master)is a record for each date the class meets.

A grade record is created for each student for each class session there is for the class to which the student is assigned. This grade record contains the grades and attendance for each particular session.

The problem pertains to situations where a student changes classes in the middle of the year. If the class assignment is changed in the profile record I need to change all of the grade records to show the new class link because the grade records are linked to the student as well as the class master table.

My intention has been to set an indicator in the profile record at the time the class field has changed and before leaving the screen (page of the pageframe for the profile record) requery the view for the grade table and update the view.

At present the view for the grade table is not part of the bizobj for the profile page. I have tried to add a 2nd bizobj to the page and do a dynamic swap but get an error relating to the setting of 'lnorecords'. I have tried to dynamically change the data environment of the original bizobj but get a message about requerying another view within another transaction. Both of these attempts were triggered from the postsavehook of the existing bizobj.

By the way I need to be careful because this is a modification to an app that is in production.

This is a lengthly explanation but it is an involved process.

I have not tried to add the grade view to the profile bizobj. This may be a possibility.

Regards,

Bill