Here is what I am trying to do:
Pull WordFly email list and output to send Donors a "review your Program Listing"
1 - Emails are kept on individuals
2- Program Names are on the Household (Where the transaction lives)
So for email list - I replace with Adult Members of the household - then I can't get the Program Name on the Household.
I am guessing I could make a VIEW to handle this but I am at a loss as to where to start.
Thanks
Mary
Sounds like a view. VS_ELEMENTS_RELATIONSHIPS might be a good place to start or even Chris Jensen's lv_household_w_affils view and add in the Program Names from VS_ELEMENTS_PROGRAM_NAME
Heath Wilder Thanks! That got me in the right direction! And as a result I can get me output - it may not be the cleanest way but it all checks out! And got a few other things done with the same logic!