Somewhat stuck in bowling db

[DJBummy]

I am trying to create a bowling league db in access 2003. I believe I have started with the right structure but I am having some trouble with recording the scores of the bowlers. Attached in a word doc is how I have set up the relationships. Any thoughts would be greatly appreciated.

D.J.

 

[ColinEssex]

You only need the BowlerID as an Autonumber. Also, why bother with the Lane table? The lane number can go in the schedule table.

Col

 

[DJBummy]

Thank you for your quick reply. The league consists of 10 teams bowling on 5 sets of lanes for 32 weeks. Each team will play on a different lane each week. For example 1 vs 2, 3 vs 4, 5 vs 6, 7 vs 8, 9 vs 10 on lanes 27,28,29,30,31,32,33,34,35,36. Correct me if I'm wrong but with normalization don't I need the Lane table to achieve this? I appologize.My experience in creating databases amounts to 1 every two or three years.

Thanks

D.J.