New to sheltermanager

[presse55]

New here, I hope I am posting at the correct location.

I wish to build a query relating to adoptions.
Specifically I wish to find the owner, and the 'donor'
I am experienced with SQL, I can link and find the current 'owner'.
However I cannot quite figure out how to fetch the 'donor'.
I believe the 'ownerdonnation' table may be involved, I do not know which columns to key on.

Thanks in advance for any guidance!

Ron

[bobintetley]

you can link the ID of the current owner to ownerdonation.OwnerID in order to find payment records linked to that person. There's also a MovementID column in ownerdonation that can be used to identify payments linked to the movement/adoption table. Finally, there's a Donation column in adoption which contains a total of all the payments for that movement.