Lynn Pettis (4/7/2010)
It may help to see the whole problem not just a piece of it. Can you put together a test suite including the expected output? I know I work better when I know the whole problem, and can see what the end result should be.
That post would contain about 500 lines of code and another 2000 to build the relevant objects and test data which I'm sure I can't provide because it contains personal data. And of course there's even more to it than what I said but those missing pieces are basic joins to other tables, nothing relevant to my little problem.
I have everything working except the piece to build all possible combinaisons which is where I need help. Other than just going with a loop I don't see any easy way out of this one.