robertstaflin

Newbie help with messy database

Discussion created by robertstaflin on Jan 1, 2014
Latest reply on Jan 2, 2014 by gdurniak

I'm trying to make a grading database for one of Swedens iaido schools. I've made four tables:

 

person (a person)

handelse (an occurence, i.e. a person graded from one grade to another at a grading)

gradering (a grading)

grader (the differing grades)

 

In a layout called Person, I want to show the latest grading from different categories, so for "normal" grades in the "grader" table I want the latest grading below id 18. Hence I use the following formula:

 

If ( Max(Tillgrad::id) < 18 ; Max(Tillgrad::id) ; GetValue ( Tillgrad::id;1))

 

...where Tillgrad is a "copy" of the grader table.

 

The problem is that it seems that I always get the value from Frangrad (another copy of the grader table). Please take a look at the attached pdf file... *Sob*

 

I've also tried working with a portal to get the latest grading information, with much the same result - I get the value from the "Frangrad" (the grade from which the person graded to something else).

 

Should I just start over, and use separate tables for the different grade categories?

 

Thanks for any input.

Attachments

Outcomes