Is a "Biochem Range" a record in a table? or does this also a reference to Biochem records.
I think I may have figured that I will have several ranges, specific to male/female and different ages. Each patient may have 1 or more of those ranges allocated to them in their lifetime. So I think after all it's 1 (patient) to many (biochem ranges).
But how will you link "range" records to Biochem records?
I can visualize more than one possible data model.
Good point and yes, your suggestion may be the answer. I will check.