Create a new table in your file, Mats, called Courses (click the tables tab). Make it look exactly like Comment's file (including the calculations). Then in the graph join just like Comment's file shows:

Courses::StartDate = Anmalda Register:Kursstart

... you have it joined to the end date Kursslut (I think). I'm a bit lost in the language but Kursstart, and the fact that the calculation [color:green]LeftWords ( Import. Datum ; 1 ) is the starting date. You also have Kursstart as data type NUMBER and it must be date.

Look in Comment's file and re-read the posts. I realize it's difficult for you because of language but it's important. There are TWO layouts - one is based upon the Registration records ( your Anmalda Register ) and the other layout is based upon the new Courses table (which you need to create first). If you view the Courses layout, you will see your courses 1, 2, 3 with dates that you TYPE IN. After you type in your 'criteria' in these records, the relationship will produce a MATCH. When the Course Start Date matches records in Registrations (Kursstart calculation DATE), the relationship will be valid. Then place the Courses::CourseID on a Registration layout. Keep working with Comment's file and re-read these last few posts a few times as you go through his file.

LaRetta

Edited March 10, 200718 yr by Guest
added a bunch more

Thanks for the help every body. It's working like I want now ;)