Re: Identifying Relationships - Help!

You need one more table:

Consults(ConsultID*, PatientID*)

Join the other tables to this one.

Zap wrote in message <8g09pd$1f5o$1_at_probity.mcc.ac.uk>...
>Hello there,
>
>I have a question about Relationships.
>
>take this example:-
>
>A consultant be shared by many patients and a patient can see
>many consultants. Is this a M:N relationship? If so, then when I
>create these relations in access:
>
>Consultant (ConsultID*, Name, PatientID)
>Patient (PatientID*, Name)
>
>And take the join across Access creates a 1:M join. Am I
>misunderstanding something fundamental here? I know that in
>order to model a m:n relation I need a junction table, but as an
>experiement I tried the above join in relation and Access created
>the 1:M join. Am I effectively modelling the situation, or does there
>exist only a 1:M relationship between these two entities or am I
>right in thinking there is a M:N relationship.
>
>Thanks in advance
>
>Zap
>
>
>
>
Received on Thu May 18 2000 - 00:00:00 CEST