I'm trying to design a new data entry form (tabbed) for my church's membership database.
The DB has two linked tables
• Table1 [Linked as Parent] is for Family Info...address, home phone, mailing label names, etc.
• Table2 [Linked as Child] is for Individuals' Info within each family...personal name, cell phone, email, etc.
So a single Table1 record is likely linked to multiple Table2 records.
What I would like to have is a tabbed data form that has Family Info on one tab and Each Individual on another tab.
I can get Family Info on one tab and a single Individual Info on the other. I'd like the form to contain one Family Info tab form AND a tab for each of the individuals linked to the Family.
I can't figure out a) if this is possible or b) if it's possible, how to carry it off.
If this can work, I'd also need some way to add Individuals to the Family from this form for data entry purposes.
Thanks for any help you can provide. Please ask if I've not provided sufficient detail.
Chris