when two foreign keys in same table(Match) referencing primary key in another table( Team)(. Powerpivot)

[harsha547]

Can I know , how to establish relationship between two tables in PowerPivot.when two foreign keys in same table(Match) referencing primary key in another table( Team).Match ( Match_Id (PK) , Home_Team(FK) , Away_Team(FK) )Team ( Team_ID (PK) , Team_Name )Both Home_Team and Away_Team columns are referencing to Team_ID in Team Table

 

[Matt Allington]

I don't really understand your question. A relationship is between 2 tables, one side has a PK and the other has a FK. You just drag the columns to each other in the relationship view and the relationship is created. It is not relevant if there are 2 records in the FK table or not - the relationship is the relationship.