Newbies jackk Posted November 5, 2012 Newbies Posted November 5, 2012 I have a school administration application. On a Staff page that shows a Teacher's record, I have two portals. On the left, the portal shows a list of the Courses taught by that Teacher. Clicking on one of these portal rows displays the Students taking that Course in the right portal. A button next to the Student's names takes the user to a screen where he/she can enter the Student's grade for that Course. My problem: on returning to the Staff page, I've lost both portals' focus (they've both returned to line 1). I've tried saving the portal rows, both as global fields and variables, but these both seem to be "automatically" changed (ie not under control of a SetField or SetVariable statement). I am at a loss to figure out what is going on and how to address/solve this problem. Thanks for any help or insights.
comment Posted November 5, 2012 Posted November 5, 2012 In which table is "the Student's grade for that Course"?
Newbies jackk Posted November 5, 2012 Author Newbies Posted November 5, 2012 The tables are: Staff ==>(1 to m) Courses ==>(1 to m) Registrations ==> (m to 1) Students. The Registrations hold the StudentID, the CourseID and the Grades.
comment Posted November 5, 2012 Posted November 5, 2012 Staff -< Courses -< Registrations >- Students Why don't you make the right portal look into Registrations? That way you can view/enter the grades directly, without leaving the current record and layout.
Newbies jackk Posted November 13, 2012 Author Newbies Posted November 13, 2012 This is difficult, as an important component of the grade is a text comment, usually of several paragraphs, in which the teachers formatting. There is just no room, with the list of courses on the left and the list of students (with a grade summary) on the right.
comment Posted November 13, 2012 Posted November 13, 2012 Ok, then make your button go to the related record in a new window. When they are done, let them close the window and return exactly to where they were before.
Recommended Posts
This topic is 4392 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now