I am in need of a solution to accomplish the following;
Transaction Table fields
ParticipantIDfk (from related particpant table)
I have 100 plus record in the transaction table.
I am set with the transaction table.
I am in need of a display/report by participant along with the amount by each employer.
For instance John Doe has the following records (contributions on their behalf) in the transaction table
Name Amount Employer
John Doe $100 ACME Manufaturing
John Doe $100 Spacely Sprockets
John Doe $150 ACME Manufacturing
John Doe $25 Mels Diner
Jane Doe $75 Mels Diner
Jane Doe $75 ACME Manufacturing
The results I need are a display or out
Name ACME Spacely Mels Total
John Doe $100 $100 $25 $225
Jane Doe $75 $75 $150
I was toying with a transaction/participant join table. I understand the total column will be a summary of each column but I am not sure how to tag the columns Acme, Spacely, and Mel's to display by the participant.
Thanks for the help.