AnsweredAssumed Answered

Relationships on reports question

Question asked by ngilleo on Jan 19, 2012
Latest reply on Jan 20, 2012 by philmodjunk

Title

Relationships on reports question

Post

I have three tables: Mammals, Birds and Donors.  I have a field in each table for "donation" and an additional field in the donor table for "other donations" (non-monetary).  The relationship I have to each table is "last name" and "donation".  I want a report for Donations and have the fields Last Name and Donation in the report as well as some others.  The report is giving me some information correctly from the other tables but for other donations in those tables, it appears to be adding donations as a total for different people to one Last Name.  The other Last Names don't show up.  Still quite new to FM.  What am I doing wrong?  Any help would be greatly appreciated.  My representation is in Excel since I'm at work and can't access the file.

Thank you!

 

FM_Tables.jpg

Outcomes