Hoping someone can point me in the right direction in filling a data request I received this week. Our development department has been adding a value for benefactor on manually created memberships and wants to report out the results, but after looking at the Table Structures doc I cannot seem to find where this value would be stored when no contribution is attached to the membership record. Can anyone point me to a report or a table where I could locate this?
I appreciate any advice or ideas you have.
Hi, Sadie:
If you can get the cust_memb_no from TX_CUST_MEMBERSHIP, that turns up in TX_CONT_MEMB, tied to a cont_ref_no that equals the T_CONTRIBUTION.ref_no.
I guess you could make a list of people at the benefactor level and filter out those who have a cont_ref_no value in TX_CONT_MEMB.
Hope that helps.
Lucie