Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    UK, by the sea
    Posts
    2

    Unanswered: league type database

    Ok, a newbie here but ive done a search and not found anything like what I need, so here goes

    I am currently constructing a DB to enter in football (soccer info)

    What I am getting stuck on is a table to list all the games

    ie,

    team1 v team2
    team1 v team3
    team1 v team4
    .........
    team20 v team19

    This will consist of 20 teams times 38 games.

    Rather than type in 760 records manually, is there an update query that could generate this table for me.

    At present I have a table to contain all the teams

    tbl_teams

    2 fields,
    teamid
    teamname

    and the table to get updated

    tbl_Games
    6 fields
    GameID
    GameDate
    HomeTeamID ... same as teamID
    AwayTeamID ..... same as teamID
    HomeTeamScore
    AwayTeamScore

    Can this be done???

    any help appreciated

    akky

  2. #2
    Join Date
    Sep 2003
    Location
    UK, by the sea
    Posts
    2
    aaahhh, I think i am on the right track

    in a new query I have added the tbl_Teams twice and put the same field from each table. However this has only generated 400 entries, Half of what I need.

    Also team1 vs team1

    team2 vs team2 are still present

    Any advise grateful

Posting Permissions

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