I have a product catalog that is automatically created from the line item records in an inventory table. The script that creates the catalog sorts the products by category and via the use of a sub-summary the catalog comes out nicely with headers at the top of each new category as you flip through the book.

However, I would like to be able to have a table of contents automatically created with the page numbers of each category. How might this be accomplished? Basically I would need Filemaker to be able to calculate on which page each new category would begin when sorted by category. I hope that makes sense.

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/175171/post/198976/#198976

That post appears to have the solution if you are looking to have an index with page numbers for every single record. With my data sorted by a sub-summary I only need the page numbers of each new category. In my catalog of maybe 100 products there are 5 or 6 different categories. So I'm needing a table of contents showing the page number on which each new category starts.

I'm going to mess around with the solution given though, and see if I can make it work.

That post appears to have the solution if you are looking to have an index with page numbers for every single record.

No. It discusses methods "to generate a group index, i.e. only showing the page on which a group of records starts".

Ah, so it is. I guess I misunderstood it the first time I read it.

And good news, I have since utilized the technique to create my table of contents. In fact, I added a few fields and script steps myself to produce a ToC within the catalogue .pdf itself rather than as a separate .pdf.

Thanks for the help!