At 12/07/2002 12:39 AM (Saturday), Todd Brasseur <todd@...> wrote:

>First of all, thanks to everyone for your responses to my problem.
>Today I found the problem and I will try to explain in case anyone
>else runs into the same thing.
>[details snipped]

Thanks for posting the resolution for us. I'm glad you got past the problem!

One other thought: I don't know if this will work better for you but you
might consider combining the two rate tables again but with a slightly
different structure. In the new table have a Code and Rate field but add an
"IsSingleCode" field to indicate if the Code field represents a SingleRate
or CombinedRate value.