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

 

student

course1type

course1 datefollowed

course1 datevalidtill

course1 dateexpire

course2type

course2 datefollowed

course2 datevalidtill

course2 dateexpire

etc

 

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.

Outcomes