Todd: is this a medical billing program?

"Todd Brasseur" <todd@...> wrote in message
news:3DF23491.7020103@......

> The reason the two codes are separate is because the single code has a
> foreign key to a CODES table and the COMBINATIONCODE has a foreign key
> to a COMBINATIONCODE table. The CODES table is simply a a Code and a
> Name. The COMBINATIONCODE is quite complicated in that it can be made
> up of up to 6 combinations of CODES from the CODES table.
>
> Todd
>
>
>
> Doug Chamberlin wrote:
>
> > 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.
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> > <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>