Take the 2-minute tour ×  Simple question probably.  For two
tables. A one to many relation is created from A -> B, TeamID ->
Fk_Team, however there are multiple fields that need to
reference this one relationship how does that work.   A
B TeamID                     EventID teamName
datetime teamocation                homeTeam etc
awayTeam  So how do I define that homeTeam and awayTeam both
utilise the Fk_Team relationship and that the homeTeam &
awayTeam entry must exist in the TeamID.teamName field?
share|improve this question Why are they referencing the
TeamName instead of TeamID? –  Aaron Bertrand Apr 25 '12 at
15:03 @Aaron Bertrand. True they are referencing TeamID for the
details of the team name. –  sayth Apr 25 '12 at 21:50 Ok so
just keep that in mind for the code I posted below; obviously
replace dbo.A(teamName) with dbo.A(TeamID)... –  Aaron Bertrand
Apr 25 '12 at 22:07  1 Answer 1  up vote 7 down vote accepted
You can't implement