Table for a results database

[liamm]

Hi, I am creating a database to record golf competition results. I have created tables for,
Members (ID, name, handicap, classification)
Competition (ID, Title, date, format. These 2 tables have look-ups for their content.
I am stuck on how to record results for the competitions. I require the ability to select a competition, enter the results (from maybe 1st to 10th) and the score of each person. Any help on how to set this table up would be greatly appreciated

If you can help, GREAT
If I can help, EVEN BETTER

 

[lhite]

Create a table for MembersAndCompetitions. Use the Members table as the lookup for the Member field and the Competitions table for the competition field, then add other fields as needed (Handicap, Score, etc.). You'll need to query all three tables to generate reports that contain blends of information from all fields.

-Larry

 

[liamm]

Thanks, I'll try this If you can help, GREAT
If I can help, EVEN BETTER