Many to many relationship


#1

Hi
I am trying to create relationship between two tables(A and B) and common column between two tables is JobId, which have duplicate rows. I tried to create a bridge table and Bridge_AB and when I try to display values of Bridge_Ab And Table A(Job Id). I can see values, when add JobId from Table B, it gives error. I can use only either Table A or B with bridge_Ab table. Please advice.


#2

Possible to add some images here of the exact scenario?

It’s hard to image everything at play here.

Usually you will want to break out the JobID maybe into a table by itself and make it a lookup table. This mean you want the JobID column to be unique.

Will need more information though to really assist here.

Thanks