I'm sure the answer is here somewhere but I'm not sure how to search for it.
I have a database of volunteers for a medical reserve corps in the county I work for. The "Person" table is the main table for the database and is organized:
"PERSON TABLE"
Person_ID (primary key)
Last_Name
First_Name
Middle_Name
Many other fields about the applicant.
All the other tables thus far are various attributes of the applicant, eg., the type of setting they have worked in. For these I have a tables like this:
"WORK SETTINGS"
Setting_ID (primary key)
Setting_Type (refers to lookup table)
Setting_Detail
Person_ID (foreign key)
Now I need to add a volunteer training information. At first I thought I'd set it up like the others but that didn't seem to make sense. If 10 people were in the training the data entry person would need to enter a record for each participant. It made more sense to me to have a training table/form and then enter each participant in a sub_form. But this is where I'm not getting my head around. I saw it like this:
"VOLUNTEER TRAINING"
Training_ID (primary key)
Training_Topic
Training_Date
Training_Location
Training_Hours
And here is where I'm not getting how to set it up.
"TRAINING PARTICIPANTS"
Participant_ID (lookup in "PERSON_TABLE", I want the whole name)
Training_ID
I want to be able to see the full name of the participants. When I use the "PERSON_TABLE" as the lookup, I can only save one field which is the Person_ID, a number. I know I've done this sort of thing before but I don't do database work very often. I'm even having difficulty here figuring out the primary key in the "TRAINING_PARTICIPANTS" table.
Does this make sense? I'd appreciate any help. If any clarification is needed and I don't respond right away it's because I'm going to be without internet access for about a day. Thanks.
I have a database of volunteers for a medical reserve corps in the county I work for. The "Person" table is the main table for the database and is organized:
"PERSON TABLE"
Person_ID (primary key)
Last_Name
First_Name
Middle_Name
Many other fields about the applicant.
All the other tables thus far are various attributes of the applicant, eg., the type of setting they have worked in. For these I have a tables like this:
"WORK SETTINGS"
Setting_ID (primary key)
Setting_Type (refers to lookup table)
Setting_Detail
Person_ID (foreign key)
Now I need to add a volunteer training information. At first I thought I'd set it up like the others but that didn't seem to make sense. If 10 people were in the training the data entry person would need to enter a record for each participant. It made more sense to me to have a training table/form and then enter each participant in a sub_form. But this is where I'm not getting my head around. I saw it like this:
"VOLUNTEER TRAINING"
Training_ID (primary key)
Training_Topic
Training_Date
Training_Location
Training_Hours
And here is where I'm not getting how to set it up.
"TRAINING PARTICIPANTS"
Participant_ID (lookup in "PERSON_TABLE", I want the whole name)
Training_ID
I want to be able to see the full name of the participants. When I use the "PERSON_TABLE" as the lookup, I can only save one field which is the Person_ID, a number. I know I've done this sort of thing before but I don't do database work very often. I'm even having difficulty here figuring out the primary key in the "TRAINING_PARTICIPANTS" table.
Does this make sense? I'd appreciate any help. If any clarification is needed and I don't respond right away it's because I'm going to be without internet access for about a day. Thanks.