I used to be able to do this in Crystal Reports but Trying to get the hang of FileMaker 12 Pro.
I have a table with all of the contacts and another table where items are scheduled into a calendar that is actually linked to another FileMaker 12 program. I can see, add, and change the data in the calendar without issue. Here is my issue. I am trying to get my report to report all the contact information along with only one entry made in the Calendar for that contact. We hope to use the calendar to track when we go to the address of the contact.
So far I can only get the report to only show the first calendar event made for that contact. I have not figured how to generate the report through a script that used the primary key of the calendar event within the portal. I hope someone will be able to help. I have spent hours trying to figure this out and digging through help sites. Thanks in advance!