Help with Database Design

[neo651]

I'm trying to keep track of a survivor league pool using Access but I can't figure out how to put it together. Here are the rules of the league.

Participants pick a single NFL team each week. Should that team win their game they continue into next week. If that team should lose their game the participant is out of the pool. Each participant can only pick any given team once. Once that person chooses that team they cannot select them again.

I can't figure out how to put this together in an Access database. I need to be able to add Participants on the fly, I need to keep track of picks. Pick objects are composed the Participant, their Team selection, which Week the selection is for and what the Result of the game was (Win/Loss/Tie). And I need to prevent users from allowing a Participant from picking the same Team twice.



Any ideas anyone?

Thank you.

[June7]

Google: access database survivor pool

Maybe this will help. This site http://www.brainjar.com/AspFootballPool/ has a template for creating a web-based pool. It also provides an Access database as the data file. Unfortunately, Relationships are not built and there are no queries, forms, or reports nor any coding.

Also review this 'how to' from the same site http://www.brainjar.com/AspFootballP...ol/readMe.html

Other sites of interest
http://www.officepooljunkie.com/
http://www.bettorschat.com/forums/po...pool-free.html

[neo651]

I appreciate the help in getting the task done, and as much as I am interested in organizing my survivor league I'm doing it in Access as an exercise to learn more on how to use the program. So I'd like to learn and understand the ideal way to set up these tables. And without relationships defined in that sample database I'm not sure what to make of it. Thank you, though.

[June7]

Review the 'sticky' thread tutorials here http://forums.aspfree.com/microsoft-access-help-18/
I've never seen an Access project on this app before. No idea how it would be set up. Would have to do the analysis outlined in the above link. Attempt design and post your schema for analysis.

If you explore the database from the earlier link might be able to figure out the relationships by identifying primary and foreign keys.