tstspclst

Thanks again

Your solution worked perfectly. I actually implemented it with a self-join because I am developing this for people with little familiarity with FMP and wanted to keep it simple. Thanks!! You wouldn't happen to know how to: 1. force a subsummary to page break when the records in a category will run over to a second page? 2. enter the total pages of a document in a footer so, e.g., "page 1 of 7" can print?

I need help displaying data. Each record in the database contains, among others, fields for teacher number, period taught, course taught and period iteration (i.e., whether the course is the first among those taught that period, the second, etc.) I want to display in a table format the courses taught by teachers by period. The teachers should appear in rows and the periods in columns, with the names of courses in the intersections. (To complicate it, sometimes a teacher will teacher more than one class in a period, but that's not really a problem.) I've come to the conclusion that I need a portal for each period, but I don't know how to develop a relationship that will display just the courses for a given teacher-period combination. Please forgive if the description of what I would like to do is clumsy as I am new at this. Any help will be greatly appreciated.