Relationship Needed to get merged letters

[brzfan2]

I am trying to get my merged letters to work. I think maybe my relationship is wrong. I have a Participant table and a Payment table. They are related by ID, First and Last Name. I have a portal in the participant table to enter payments into the Payment table. I have written a script to go to the Payment Table and find all records with the current date. It does find the records but it lists them as 1 record with 2 or more entries per relationship. When I continue to try and merge the information I only get a letter for the first record for each participant. How do I set up the relationships so both records will print merged letters? The letter is a receipt of payment and I need one for each payment entry regardless of participant while still maintaining the relationship of payment to participant. I hope this makes sense.

[transpower]

Since you need to print a letter for each payment entry, you should print from the Payment table, not the Participant table.

[brzfan2]

Thank you. That worked. I thought it must be something simple I was missing.