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.
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.