Database design for volunteers

[HamBus]

I'm trying to build a database to manage a group of volunteers. The end result is that I need a report with the total hours worked by each person for each activity, and then the total hours worked by all volunteers on each given day.

I already built the table containing the information for each person (name, surname, etc.). I also made a table with the activity and hours. I gave a unique volunteer number for each person and assigned this field as my key.

Then I created a relationship between these tables. I did something wrong because I keep getting an error message when I try to add 2 different dates and hours for a person.

Did I wrongfully create these databases ? Is there a better, and simpler, way to achieve my goal.
Thank you.

[June7]

Need to know more about data structure. If you want to provide for analysis, follow instructions at bottom of my post.

[orange]

It's hard to say what may be the issue without seeing your tables.
From your description I see 3 tables involved (and I might not be seeing the proper picture)

Volunteers----->VolunteerWorkedOnActivity<----Activities

Volunteers
VolID Auto PK
VolFName
VolLName
other Vol info

Activities
ActID auto PK
ActivityName
ActivityLocation
other Activity info


VolunteerWorkedOnActivity
VolActivityID autonum PK
VolID FK to Volunteers
ActID FK to Activities
VolActDate Date of the Activity ' suggest this for part of Unique Index
VolActStartDtTime Date/Time 'for Time reporting
VolActStopDtTime Date/Time 'for Time reporting
other info specific to this Vol, this Activity, this Date


The three fields in red would form a unique composite index to prevent duplicates.
The 2 fields in black are for getting the hours worked on a particular "ActivitySession"

This is for your consideration recognizing that we know very little about your environment and "Business".

Good luck with your project.

[burrina]

I attach a screenshot that may give you some direction or at least an idea. It shows a job and time on that job and you can have many people or volunteers on that job.