table relationship in query

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

Should it be table relationship in query the same as the relationship of
table when we first designed it?

I asked this because I have a problem in membership table I have pathid, so
this could be many, while in the Imagetable I will have also many member
number, So is it many to many. I am confused on this

Thanks for any idea provided
 
Frank Situmorang said:
Hello,

Should it be table relationship in query the same as the relationship of
table when we first designed it?

I asked this because I have a problem in membership table I have pathid,
so
this could be many, while in the Imagetable I will have also many member
number, So is it many to many. I am confused on this

Thanks for any idea provided
Click to expand...


Joins in a query do not necessarily have to be the same as the relationships
between the tables, no.

The relationship is many to many if each record in the membership table can
be associated with more than one record in the image table and each record
in the image table can be associated with more than one record in the
membership table.

Many to many relationships are implemented by using a third table to link
the two tables. For example, to implement a many to many relationship
between members and images you might have a MemberImage table that would
contain two fields, MemberID and ImageID, with a multi-field unique index on
the combination of the two fields. The relationships would be one to many
between members and MemberImage, and one to many between images and
MemberImage.
 
Back
Top