Have a clarification on many to many relationship in physical data model. In a table can we create many to many relationship for a FK column ?
Here is an example: Table A has two foreign key columns with other non key columns. Data in this 2 FK columns will have multiple records associated to parent table B and C.
I tried to create many to many relationship between parent table PK column and child tables FK column by selecting M:N relationship in TDM. After pointing to both parent and child table, by default a bridge table is created.
However, from the bridge table relationship I am unable to point the child tables FK column. Please advise.