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

Katey,

You haven't provided the most important information of all:- where are the officers identified as officers and how and where is their rank stored??

At a wild guess, it sounds like you may have a Rank field in the members table? If that's the case, then I suggest you create a calculating global field in the chapters table which lists all the ranks (one to a line) then set up your relationship definition (ie the relationship you're using for the portal), as follows:

ChapterID = ChapterID

AND gCalc = Rank

..where gCalc is the global calc field in the chapters table and Rank is the field with corresponding values in the members table. :wink2:

Another way, perhaps more suitable for a printed report, is to find the members who belong to the Dallas chapter AND have anything in the Rank field. Your report would be a list layout based on the Members table, with the common chapter information in a sub-summary by chapter part.