7 Replies Latest reply: May 7, 2015 7:00 AM by sunil kumar RSS

    Relationship problem

    Peter Hendrikx

      Hello,

       

      I'm trying to create a data model to get this end result:

       

      Stage# Students
      noStage1
      Stage21
      Stage32

       

      Table one contains Student data

      StudentID
      1
      2

      3

      4

       

      Table two contains for each student zero, one or more trajecten

       

      StudentIDTrajectId
      11
      42
      2

      3

      3

      4

       

      Table three contains for each traject the last action, if an action is available

       

      TrajectIdLastActionId
      113
      215
      418

       

      Table for contains all the action records

       

      TrajectIdActionIdStage
      111Stage1
      112Stage2
      113Stage3
      214Stage1
      215Stage2
      316Stage1
      317Stage2
      318Stage3