Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010
    Posts
    3

    Can someone help me with this?

    Hey im new to database design and having trouble trying to figure this one out. I have two tables Team and Fixtures. Team has rows of football teams and Fixture has 2 of those football teams in each row (home and away team). I want to link team id to home_team and away_team but it doesnt allow me to. How can i solve this please?

    I've attached a picture of the relationship.
    Attached Thumbnails Attached Thumbnails access.jpg  

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Croga View Post
    I want to link team id to home_team and away_team but it doesnt allow me to.
    what is this "it" that won't let you?

    because you posted in the Database Concepts & Design forum, i should tell you that what you want to do is really straightforward using primary keys and foreign keys

    what software are you using?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •