Relationships on reports question
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.