No Unique ID Column in neither tables

[dommyw277]

Hi, so i have 2 tables and neither has a unique value in any column. One table is cached data and the new table is live data. 

I have Product ID on both and Billing account ID in both but both columns are not unique and if i update the data in the live table surely it will just fail again after i have added a unique column? 

[dommyw277]

Hi, i have linked all 3 tables but cant the visuals to display any data, any ideas? 

[mh2587]

Just bring those IDs in bridge table and remove the duplicates and then manage the relation among these tables that will be 1 > *

[dommyw277]

Hi, could you explain that in a bit more detail please?

[mh2587 · Accepted solution]

Make New Table with required IDs and remove duplicates then connect this new table with each tables through common ID and the relation will be one to many.