An intermediate table?

[gstudio]

So I'm new to MsAccess but I am doing a project about a football team where i have already done 2 tables - footballers(ID[PK] ,name,age,team,price,salary,shirt number,yes/no participating in tournaments) and teams(ID[PK] ,name,country,year founded). Now I was told to create a relationship with a new, third table (Competitions), for which I got an advice to be intermediate - without using a primary key. Can someone explain what I should include in this Competitions table and how can i manage the relationships? Thanks in advance!

[ranman256]

the 1st 2 tables are the source tables
ballers feed teams
teams feed Competitions. This holds the results of the game.
each tCompetition has 2 teams ,usu: Home,Guest, HomeScore,GuestScore, GameDate
this can then calc the wins/loss count

the team fields dont need keyed, but do index them.

[orange]

gstudio,
You may get some insight and ideas from this article.

[gstudio]

Thank you both very much!