Circular ralationships

B

bhammer

Is it wrong to have tables with relationships that form a circle between, for
example, 6 tables? In my Relationships window, I can arrange the tables in a
circle and each is related to the table on the right and left, forming a
chain. Is this a violation of normalizing? Two of the tables are junction
tables, if that matters, but that's my next question.
 
M

mscertified

There is probably a better way to do it.
Could you explain what the tables are and how they are related?

-Dorian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

same field in more than one table 2
"Circular" Relationship 3
Convoluted many-to-many relationship 9
Junction tables 4
Manage many to many relationship between "N" number of tables 1
Second Thoughts on Normalizing 11
Will I need a junction table in this scenerio? 12
Show all from tables in my junction... 1

Top