Selecting records for merge fields

[timcopeland]

I have a simple database with two tables: People and Donations.

The People table contains contact information on donors. The Donation table contains records of each donation. The two tables are linked via a Person ID number. The list of donations from the Donation table appears in each record in a layout in the People table via a portal. All of this works fine.

I want to create a letter as a layout in the People table and use data from a field in the Donation table in that letter as a merge field. I have been able to do this successfully EXCEPT if more than one Donation record exists for a donor, I have not been able to figure out how I can select the specific Donation record I want to appear in the merge field.

Help and advice will be much appreciated.

Edited December 13, 2005 by Guest

[Raybaudi]

Hi, timcopeland

I think that the simpler way is to make the letter in the Donation table.

So, it will be pretty simple to take the right donation for the merge field... and the donor too !