In Toad Data Modeler ( version 2.25) , what do I have to do to avoid FPK in a NM relationship between 2 tables :
Suppose I have 3 tables A, B and C with following attributes :
A (a_id, b_id) with a_id as PK and b_id as FK
B (b_id ) with b_id as PK
C ( c_id) with c_id as PK
Now I want to create a NM relationship between A and C : AC (a_id, c_id)
When I use the “Relationship N:M” button to create it, it automatically create :
AC with a_id, c_id but also b_id (!!) , that is what I want to avoid.
Do I have to change any option?
Thank in advance for your help