Help with Report - merge fields with two or more related records
I am new to FileMaker and though I have read a lot of the posts here, I still haven't been able to solve my issue. I am using FMPro 11.0v4 on a Mac. I work for an entertainment company that sends out various entertainment for parties (such as disc jockey and karaoke, or disc jockey and novelty photos. I have set up our database in the following manner:
My issue comes with how to create our contract. We were previously using ACT which allowed me to "write" a word document that would use merge fields to input the information but then I could edit it as needed (which created its own problem of our database not being accurate). So, with our new FileMaker database, I have a layout for contracts and have all the info inputted via merge fields. My problem comes when I have an event that has more than one related EventEntertainment record. It will only show the first one listed.
This is how I currently have the "Contract" layout (from the event table):
We will provide <<EventEntertainment:Number of Hours>> of <<EventEntertainment:Product Name>> for a total price of <<EventEntertainment:Rate>> during the hours of <<EventEntertainment:StartTime>> to <<EventEntertainment:EndTime>> on <<Event Date>>
I would like this to repeat on the contract for each entertainment product selected for that event. If I switch the contract layout to pull info from the EventEntertainment Table then it gives me a seperate contract for each entertainment product selected. I would like it to all be contained on one contract. Basically, like an invoice with line items but much more text!
I hope I've provided all of the needed information. Any help would be appreciated.