D
dee
Hi,
I am trying to create a form and two sub-forms for family meetings in a
small school. The form should show:
Main Form: (Fields taken from query based on TblFamilyInfo to sort by family
name)
FamilyID (hidden)
FamilyName, MainPhone (that is used to tell families with same names apart)
SubForm1: (Fields taken from TblFamilyMeetings)
FamilyID (hidden) - child/master link between Main and Sub1 forms
MeetingID (hidden)
DateOfMeeting
SubForm2: (Fields taken from TblFamilyMeetingDetails)
MeetingID (hidden) - child/master link between Sub1 and Sub2 forms
MeetingDetailsID (hidden)
StudentID
ContactID
ContactRoleID
The main form and sub-form work fine - no problems.
When you click on the subform1, you see the details on sub-form2 of the
meeting on that date. (Both sub forms are in datasheet format)
Where I'm running into problems is subform2. I need to be able to input the
details of a meeting, including the fields I mentioned above. However, there
may be up to 4 students attending from the family (up to 4 children) and up
to, say, 3 or 4 family member (contacts).
I'm not sure of the best way to set this up on the sub-form. I can used a
query that concatenates the ContactLast and ContactFirst names so they can be
selected in a combo box and will populate the ContactID field, but I'm stuck
on automatically populating the RoleID (father, mother, uncle, etc.) of the
contact so that is displays the actual role but populates the RoleID field.
Also, how do I deal with multiple family members and students?
I hope this is clear enough! Thanks for any assistance.
I am trying to create a form and two sub-forms for family meetings in a
small school. The form should show:
Main Form: (Fields taken from query based on TblFamilyInfo to sort by family
name)
FamilyID (hidden)
FamilyName, MainPhone (that is used to tell families with same names apart)
SubForm1: (Fields taken from TblFamilyMeetings)
FamilyID (hidden) - child/master link between Main and Sub1 forms
MeetingID (hidden)
DateOfMeeting
SubForm2: (Fields taken from TblFamilyMeetingDetails)
MeetingID (hidden) - child/master link between Sub1 and Sub2 forms
MeetingDetailsID (hidden)
StudentID
ContactID
ContactRoleID
The main form and sub-form work fine - no problems.
When you click on the subform1, you see the details on sub-form2 of the
meeting on that date. (Both sub forms are in datasheet format)
Where I'm running into problems is subform2. I need to be able to input the
details of a meeting, including the fields I mentioned above. However, there
may be up to 4 students attending from the family (up to 4 children) and up
to, say, 3 or 4 family member (contacts).
I'm not sure of the best way to set this up on the sub-form. I can used a
query that concatenates the ContactLast and ContactFirst names so they can be
selected in a combo box and will populate the ContactID field, but I'm stuck
on automatically populating the RoleID (father, mother, uncle, etc.) of the
contact so that is displays the actual role but populates the RoleID field.
Also, how do I deal with multiple family members and students?
I hope this is clear enough! Thanks for any assistance.