duplicate amounts - join problem possible with 2 financial tables? 1

[mwhalen]

I have 2 financial tables - one for pledges and one for gifts. Each table can contain 1 or more records for the same customer id. When I drop the unit.amount from the pledge table I get the right number of amounts and totals. But as soon as I link the customer id from the pledge table to the gift table and also drop the gift.amount from the gift table, I get repetitive rows and thus wrong amounts coming through. I have been working at this for some time and it doesn't seem to matter how I group it, how I join it, how I format my running totals...the detail lines are consistently wrong once I add and link that second table and drop that second amount field on there. PLEASE HELP!!! Thanks!

 

[synapsevampire]

Perhaps you have another table which you should be using, such as the Customer table?

Try joining each table to it using a left outer.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[dgillz]

Record duplication can be an issue when you are dealing with many to one relationships. Use running total fields to get the proper total for these fields, and you may need to hide the details section and display the recordsin the group header or footer to only show the record once. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com