Otis wrote:
If the 2 names are retrieved from the same table, a typed list is indeed out of the question as it has to join twice with the same table. (I really really really hate it that it can't be done now, trust me on that, if I had the time to fix it NOW I'd do it, but it has to wait till the next runtime revision.)
For performance reasons, I don't think it would have mattered much.
Thanks for the quick answer (they're all quick answers with you!).
For the time being we will code a sproc to handle this. When you get around to this enhancement, we'll convert our code.
Thanks!
--Bruce