unable to create one to many relationship

[shyamji]

Hi,

once i create many to many relationship between two tables after that i am unable to create one to many relationship with other tables.

suppose i have 3 tables A,B,C . Tables B and C have many to many relationship on column hournumber and now i try to create one to many relationship between tables A and B on column clientId but unable to create this relationship.

Thanks

Shyamji

[edhans]

Can you go to your model tab, give us a screenshot of what that looks like, then right-click on any table, click Manage Relationships, and show us what it is not allowing you to do when you create a new relationship?

[shyamji]

A great thanks for reply , 

please review below screenshot

[Greg_Deckler]

You are unable or it shows up as a dotted line?

[shyamji]

Thanks for reply.

please go through below screenshot

[edhans · Accepted solution]

This is because of your many-to-many relationships, or bidirectional filters. You should study this document from MS. You may be able to avoid Many to Many using bridge tables or other methods. Many to Many can be good in the right circumstances, but it causes issues. I use them as a very LAST resort. I prefer bridge tables as they keep the model a bit cleaner and you avoid the ambiguity problems. They, however, don't solve all issues. It is a matter of what works best in your scenario.