Hi all:
I'm new to Access and DB design, but have enough of a background to get myself into trouble. Here comes my question.
Background: I created an Excel solution for a fishing tournament. It works good, but I would like to try to learn Access and thought converting my Excel solution would be a good project to start off with.
Here's the scenario.
I have teams of up to 6 people fishing on the team, one of which needs to be marked as a captain. (the captain will have additional contact information, such as email and phone number)
I also have individuals who fish but who are not on a team. (all individuals will also have contact information such as email and a telephone number)
I need to tell the difference between teams and individuals.
Then i need to record different species of fish that are caught, how long they are, the type, and the girth of their belly. for example john doe caught 3 fish--> fish 1 bluefish at 15" 10" girth, fish 2 is a striped bass 30" 14" girth, fish 3 is a sun dial 10" 0" girth......
I know that fishermen are linked to teams. I know that they also need to be linked to the fish that they caught. How do I do this?
Do I need a fisherman table, a team table. and a fish caught table? Do i need a captain's table and an individual table.
Also I think i can handle the fields, for example male female child etc. I just need help with the relationship.
Thanks for looking,
Rocky