Hi all,

I created a TOC following the procedure described here: http://www.vbforums.com/showthread.php?t=546046 . This method displays TOC by one grouping. I need to display TOC by 3 groups and eliminate duplicates.

I know I can insert into the report 3 different formulas and display the result based on each grouping but that does not solve the problem of duplicates and misplacement of content in TOC.

I should be using global variables to mark the place of each record and sort after that.

Finally I need a report that displays

1. Section
1.1 Subsection
1.1.1. Product.

Does anyone have any idea how to implement this?

Your help is very appreciated.