Results 1 to 2 of 2

Thread: Help Needed

  1. #1
    Join Date
    Aug 2011
    Posts
    12

    Unanswered: Help Needed

    Hi There Guys and Girls

    I have finaly nealry got the design I am looking for for my database, however as you will see, where I enter the player names and scores, it duplicates the player name for home team and away team and i do not want it to do that.

    Also the form somehow does not allow me to select the home team or away team from the drop down menu, in the match date table I have two team IDS one for home and one for away these are linked to the teamID in team table but nothing appears in the drop down box.

    The add new record button does not seem to work either, so if somone could please take a look ad see wherre I have gone worng and instruct me on how to correct the mistake please.

    I know im getting close I am just little stuck now.
    Attached Files Attached Files

  2. #2
    Join Date
    Feb 2012
    Posts
    13

    Smile Tinkering required

    Ok, too many tables duuuude!
    for eg. you dont need a table TeamPlayers just to link players and teams. Use a foreign key.

    The whole design of the DB is a lil off, sorry to be honest!
    Your combo boxes will work when they are bound to some column in your list of tables. Try using the Combo Box wizard coz it will be simpler.

    I tweaked my DBs by reading and googling a lot. You should too!

    Perfect or nothing
    Last edited by nikhilstephen; 03-04-12 at 03:41. Reason: typo

Posting Permissions

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