I want to create a database that where I can input the complete NFL Schedule. Then, as the games are played, the user would input the scores for each game. I would then like to be able to calculate whether each team had won or lost the game, and keep a running track of how many points each team had scored and allowed, as well as compute each team's won and lost records and standings for home/away, division, conference, and non-conference games. The problem I have is that I don't know how to create the relationships to make this work. For example, if Chicago plays Dallas, the points Chicago scores are also the points that Dallas allows, and vice versa. I have created an Excel spreadsheet that does all of this, but I am trying to learn Access by creating this database. So far, I have created a Teams table that lists each team, and identifies the Conference and Division they play in. I have also created a Games table, that lists the date, time, home team, and visiting team for each game. Now, how do I connect them?