brzfan2 Posted February 21, 2005 Share Posted February 21, 2005 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. Link to comment Share on other sites More sharing options...
transpower Posted February 21, 2005 Share Posted February 21, 2005 Since you need to print a letter for each payment entry, you should print from the Payment table, not the Participant table. Link to comment Share on other sites More sharing options...
brzfan2 Posted February 21, 2005 Author Share Posted February 21, 2005 Thank you. That worked. I thought it must be something simple I was missing. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6996 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now