N
noodleBrain
I have two tables, tblPatient and tblReferral, with a one to many
relationship. One patient can have many referrals. However one patitent can
only have one current referral record.
Is the best way to do this to put a field into the tblPatient named
"CurrPatRef" (Current Patient Referral)?
I thought about putting a "Current" check box field into the tblReferral
table however how would I stop all Referral records of one patient being
checked - giving many current referrals for that one patient.
Cheers
relationship. One patient can have many referrals. However one patitent can
only have one current referral record.
Is the best way to do this to put a field into the tblPatient named
"CurrPatRef" (Current Patient Referral)?
I thought about putting a "Current" check box field into the tblReferral
table however how would I stop all Referral records of one patient being
checked - giving many current referrals for that one patient.
Cheers