many to many relationship

Hi,
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?

thanks.
CCVOIPAsked:
Who is Participating?
 
HuaMin ChenConnect With a Mentor System 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.
0
 
MikeOM_DBACommented:
You need two cross-reference tables.
0
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.

All Courses

From novice to tech pro — start learning today.