I need to create a data model wich include a main table DATA with references (ID) and data associated.
But I have a LINK table who associates references (ID) Together.
I want to link those tables together but I can't do multiple link.
Here below samples of tables
DATA: ( Reference , Volume, Week)
LINK ( Reference _Source, Reference _Cible)
I need to have access to the DATA details per reference (VOlumes, Week) but for Reference Source and linked Reference Cible
Data samples
DATA (A1, 200, W2)
DATA (B1, 300, W3)
DATA (B2, 50, W7)
LINK (A1, B1)
LINK (A1, B2)
I want to have a table where I can have
A1, 200, W2 - B1,300, W3
A1, 200, W2 - B2,50, W7
How can I proceed ? for the moment I created a DATA_SOURCE table with all lines from DATA contained in column Référence _Source of LINK table
and a DATA_CIBLE table with all lines from DATA contained in column Référence _Cible of LINK table
But I want all the records in the same table with some records of DATA Table linked to other records of DATA tables
I think a pivot could be the solution but I can't succeed in data modeling
Could you help me ?
Thanks