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