Subforms

[Dazed & Confused :/]

I have a very simple database that I use to keep info for a charity where
people sponsor children. I have 2 tables. 1 for sponsors and 1 for children.
I have created a form to display the childrens info and it has a subform
displaying their sponsors details. Some sponsors sponsor more than 1 child.
However, where this occurs the sponsor will only be shown for one of the
children they sponsor. When looking at the details of the children who are
also sponsored by this person the subform will be blank.
Where am I going wrong?

 

[John W. Vinson]

I have a very simple database that I use to keep info for a charity where
people sponsor children. I have 2 tables. 1 for sponsors and 1 for children.
I have created a form to display the childrens info and it has a subform
displaying their sponsors details. Some sponsors sponsor more than 1 child.
However, where this occurs the sponsor will only be shown for one of the
children they sponsor. When looking at the details of the children who are
also sponsored by this person the subform will be blank.
Where am I going wrong?

You're going wrong with the basic structure of your tables.

If each Child can have one or more sponsors, and each Sponser can sponsor one
or more children, you need *THREE* tables, not two:

Children
ChildID
LastName
FirstName
<other biographical data>

Sponsors
SponsorID
<information about the sponsor as a person>

Sponsorships
ChildID <who is being sponsored>
SponsorID <who's doing the sponsoring>
<fields about this sponsor's relationship to this child>