HorseShoes

[DBA-Meister]

I have designed a database to track scores for a horseshoe league. There are about 20 teams and four players on each team. For about 20 weeks, teams are matched against each other and each player pitches shoes against his opponent for 3 games that week.



Some of the tables are listed as follows: [ PK = Primary Key, FK = Foreign Key ]

Players Table
PersonID [ PK ]
TeamID [ FK ]
LastName
FirstName
NameSuffix


Teams Table
TeamID [ PK ]
TeamName


MatchDates Table
WeekNmbr [ PK ]
Date

MatchUps Table
Week [ PK & FK ]
AwyTm [ PK & FK ]
HomeTM [ FK ]

Scores Table
PersonID [ PK & FK ]
WeekNmbr [ PK & FK ]
Game1
Game2
Game3

I want to build a form where I can click on the "date" box and choose any particular date. Then I want to click on team name and have all four player names for that team and the four players for the opponent team listed top to bottom with three boxes next to each name to enter the scores.

I don't know whether to use one form, sub-forms, list boxes, or combo-boxes. The date box should be pre-populated with as many dates that can fit with a scroll bar for the ones that don't fit. Also, the team box should be pre-populated in a similar manner.

Anyone got a suggestion for best way to proceed

[Bob Fitz]

Not an answer to your question but you should change the field names Week and Date because these are inbuilt functions.

[DBA-Meister]

Thanks for the tip. I have changed the field names. Is there a list of all the "reserved" words?

[Bob Fitz]

This link may help: http://allenbrowne.com/AppIssueBadWord.html