Re: Identifying Relationships - Help!

But don't forget to remove PatientID from Consults.

Neil

Alan wrote:

> 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 Sat May 20 2000 - 00:00:00 CEST