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.

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?