We have a node called sponsorship that is a person, place, or thing. Person is likely a child, but it could be a teacher, nurse, etc. A person generally has one donor that pays a monthly amount. A place could be a building that would have one or more donors, and a thing is an resource; such as a projector.

Using a view we would allow the site visitor to review the opportunities for sponsorship. When the click on donate, we want to associate the donation with the item they are sponsoring. it the item is fully covered by a donation the item status would change and it would no longer we displayed to a site visitor.

We are looking for suggestions on how we should proceed.