Re: A simple Q from a beginner

On Sun, 1 Oct 2000 15:27:11 -0400, "Steve Long" <nospam_at_hotmail.com> wrote:

>Since the relationship between physician and patient is many-to-many, a
>junction entity is required to resolve this mapping, so something like a
>PatientPhysician table is required with at least PatientID and PhysicianID
>as foreign keys to their respective base tables Patient and Physician.

And since the patient might also be a physician, or the physician might be treating herself, well . . .

-- 
Mike Sherrill
Information Management Systems