4 Replies Latest reply on Oct 6, 2014 12:59 PM by tays01s

    Many to many relationship Q



      Many to many relationship Q


      I have a Patient, Biochem range and Biochem tables.

      1 patient can have many Biochem records, obviously 1 to many. However, 1 patient may several Biochem ranges in their lifetime and those ranges can apply to >1 patient. For the latter is better to have an intermediate table like 'Patient_age_Biochem range'?