D
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?
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?