I created a catalog that has a great deal of part numbers and used the TOC feature to create an index of part numbers. I did this because it was easier and faster than choosing to use the index feature since there are over 4,000 part numbers. The issue arose when the list was created in a numerical sort order of 1, 2, 10 ,11 ,13 ,120. We are looking for a lexical sort order of 1, 10, 11, 120, 13, 2. Fortunately for us, we found a script that reordered the entire list in the lexical sort order that we needed, and so we were able to print our catalog in the order we wanted. The issue for us arose when we tried to publish electronically as an interactive PDF. When we re-sort the original list using the script, the hyperlinks/bookmarks for the page numbers of each part number entry don't follow the new sort order and stay in the same spot as the original numerical list. So now we have the sort order we desire, but the links don't match the page numbers shown on the page because they are in different places now. Would we have to add a marker for each of the part numbers in our catalog and use the index feature instead, or is there an easier way to create this type of list?
TOC can be sorted in either page order or alphabetical order. Whether alphabetical order will produce the correct order is questionable, but worth a check.
I sorted alphabetically which gave me the numerical order I explained. I wonder if Adobe can easily add an additional checkbox which sorts in lexical order. I have a wish list of things I would like them to add. I come from using FramMaker for over 20 years and it's the first time I create an entire catalog in InDesign. I'm hoping they can eventually add some of the great features Frame has.
Thanks for your reply Peter.