AnsweredAssumed Answered

Student monitoring

Question asked by janbrand on Jul 2, 2012
Latest reply on Jul 2, 2012 by erolst

I,m creating a FM12pro database for student monitoring. All students can follow up to 7 courses. Each course has to be done again after one year


in one table i have




course1 datefollowed

course1 datevalidtill

course1 dateexpire


course2 datefollowed

course2 datevalidtill

course2 dateexpire



I want a layout which will show me each course ,student name and exp date

or is my table wrong.



Is there a way to get this done? Any idea is welcome!


Pardon my englisch, i,m dutch.