I have a database that keeps track of attendance at our school. I have a Family table and a student table. The students are tied to the family table by a FamilyID number. In the family table, I have a field for Mother and one for Father.
We have different things that parents can volunteer for. What I want to do is create a form where I can pull down the Mother’s name or the Father’s name into one field and then I will have the other information on the form, such as what and when, which will come from the VolunteerJob table.
My question is, how do I pull either the mother or the father into just one field? I don’t know whether I need to create a new table or if I can do this in a query. If both Mother and Father volunteer, can I pull both names into one field or would I set up 2 different records for each of the volunteers. I would also like to be able to add a name “on the fly” if I need to, for instance, sometimes the teenage children will volunteer to help but I don’t have them in the database, and they would come from a field anyway if I did. The other way I thought about doing this is to only have the Last Name of the family, which would be connected by the FamilyID, on my form and then type in the first name but it seems like I should use the information that has already been filled in.
Thanks for any help you can give me.
