• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 145
  • Last Modified:

many to many relationship

I have three table designed like following:
tab1 <= many-to-may => tab2
tab2 <= many-to-may => tab3.

I know if I have many-to-many relationship between two table, I need a cross (association) table between them.
but, can I have one cross table between the above described three tables?

1 Solution
You need two cross-reference tables.
HuaMinChenBusiness AnalystCommented:
It will make a mess if you only use one cross table. It can be possible but there would be extra work to check/confirm if the record is for which relationship.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now