I am working with Filemaker Pro 7.0. I have two databases, one with
student information(i.e. name, DOB, address, etc) and one with records
for classes that have been taken (i.e. course name, exam score, etc).
What I would like to do but have not been able to accomplish or find
any answers on this group is to have a field in student information
calculate the level of education based on completed courses. For
example,

Level 1 certified must have a passing grage in course 100,101,102.
Level 2 certified must have a passing grade in course 103,104,105.

Thanks in advance for any help available

Hello montauk372 (AT) yahoo (DOT) com,

How are the two tables/files related? For example, if you pick a student
how do you obtain the list of classes and result related to that student.
On the basis of your post it looks like a Case calculation should do the
trick but without the details it is hard to proceed.

The two files are related by studentID. Each record that is created in
the records for classes has the studentID, Course Number and exam
score. I have a portal in the student information database that
displays the courses taken by that student. I have alot of levels so
although a case formula would work I was hoping I could have a value
list that made up level one courses and a field that would be
calculated to compare the records for the student and the value list.

Dan wrote:

Hello montauk372 (AT) yahoo (DOT) com,

Suppose you produce a value list of levels where each item in the value list
is comma separated list of the courses
100,101,102
103,104,105
etc.
For any given student presumably there is just one level (if not then you
may have to repeat this procedure up to the number of levels that they might
have). So using the value list choose a level, dropping the (three?) numbers
into the field Level. Set the field Level up with an auto-enter calculation
(replace existing contents) as Substitute(Level;",";"^P"), where ^P is the
paragraph symbol. This produces the level list as a multi-key field (values
separated by carriage returns) and hence can be used in a relationship to
match each individual value. So match StudentID with StudentID and Level
with Course Number. A portal based on this relation will pull out the results
for the Level only and depending on how you want to aggregate them you can
do a Sum or Count on the related field.

OK. I haven't tried this out, so at the moment it is a theoretical solution.
But it should work. (famous last words!)