I'm using CiviCRM to manage sponsors of children in India for an NGO. I'm configured it and set up some custom fields in order to have the children(contact) connected to the membership.
So far so good, I can generate reports to see payments due, etc.
The problem is, I can not work the other way around, that is, seeing which children don't have sponsors.
My guess to solve this was to use Relationships, as I could then report and filter on that. But I've not been able to automatically create a relationship between sponsor-child when adding the membership. (doing it manually would be really tiring for the people who manage this).
Is it possible? Any other ideas on how I could go about this?
thanks in advance