Is each column for a subject a portal that shows data from the same field of different sets of records or does the data for the subject columns come from different fields in the same set of records?
A record in the semester table has only one subject. Probably doesn't matter but the records are created from the student table. student 001
Example: Record 1 KeyID 001 Year 2014 Semester 2 Subject Writing
Record 2 001 2014 2 Spelling
Does that mean that you have one more field in that record for the grade?
Assuming that to be the case, you can define A summary field in the same table to compute the average Grade. You can then put that summary field in a filtered portal to show the average for just that semester and subject.
Yes thats right, sorry I failed to mention that.
That doesn't seem to work for me. obviously I don't have something quite right. Heres what I have now
Table Semester = Table occurrence Semester2 with relationship being defined as fields Year, and Semester being equal to fields Year, and Semester and the the portal based from Semester::Semester2 then filter Semester2::Semester = "Math" ...
this seems to be working for the grades but not for the averages
this seems to be working for the grades...
And what value "works for the grades"? is this a total or other calculation? how do you compute the grades?
And HOW doesn't it work? You don't get any value or you get a value, but not what you expected?
after a more careful investigation I found the field in the portal was represent by the incorrect table occurrence. It works now. Thanks for your time