I'm a long-time user of FMP, but I'm trying to do something that's not working well for me. I've got a membership database with two primary files -- members and chapters, linked on a one-to-many relationship.
I would now like to be able to show just the chapter officers in the chapter file, so that when I pull up the Dallas Chapter, it shows their officers down below. I tried using a portal, and have gotten the officers to show up, in rank order, in the portal, but below that are all the other members who are NOT officers. (This is complicated because chapters have different numbers of officers, depending on their own unique circumstances.)
Ultimately, I would like to print out a report with the Chapter information, and then the current officers below it.
Any ideas? Thanks so much,
katey
