Best way to record auction donation without creating a new record in a form

[Snickren]

We have a database that we put all donations for a couple of our big events throughout the year into. I'm wondering what the best way to put auction donations into a form would be, as some people donate more than one auction item. Right now I have them in a table for ease of copying them into the program as we want each entry on it's own line and are able to list amounts separately. The issue I'm running into is when we go to print thank you's it is creating a new record for each one and creating a duplicate label for each donor's donation. I've tried fixing it on the query end but does not seem to be working. Is there a way for the table to not create a new record for each line used in this table, or a better option for recording?

[ranman256]

Adding a donation means adding a record.
or
overwrite an existing record with new bid.
the update query would use the key as source, then update Amt.

[CJ_London]

Is there a way for the table to not create a new record for each line used in this table, or a better option for recording?

the problem is not with your data but the thankyou report. You need to rewrite it in some way. Some suggestions to modify it - making use of the concatrelated function (google to find it) or to use a subreport for the donations as you do in your form or use an aggregate query to total all the donations.