AnsweredAssumed Answered

Many to many relationship Q

Question asked by tays01s on Oct 5, 2014
Latest reply on Oct 6, 2014 by tays01s


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'?