Hey guys, first time poster in these forums.
I have decided to learn Access, for no good reason other than I am sure it will come in handy one day especially at work. I thought to get things started I would start a local sports tipping database for a bit of competition amongst the family. I have started on the design of the database but am a little stuck on how to handle relationships. I think my question is that basic or I am that far off track that most tutorials or readings assume you'd know it, so I am turning to you.
I have a table for the fixture of the local sport. Lets say Football. It has fields: MatchId (AutoNo.), RoundNo (No.), MatchDate (date), HomeTeam (No.), AwayTeam (No.), Location (Text), Winner (No.).
I have another table for the teams that has: TeamID (AutoNo.), TeamName (Text).
I have having trouble getting my head around the realtionship between the two tables for the home team and away team.
My question is: Should I have a seperate table for HomeTeamIDs and AwayTeamIds stemming from Teams table or should the realtionship look like this?
No example I have seen shows multiple relationships to the one table from the one table (ie creating the "Team_1" shown above for relationship purposes) and therefore I assuming that this is poor design?
Thanks.