Hi,

At March 12, 2006, 1:15 AM, Anthony Tanas wrote:

> Yes, Billing is related to Payment in a one to many relationship. So I kind
> of want a "transaction log" where I have one billing line followed by all
> the payments on that line.

> It's medical so each item has payments applied specifically to it.

Not with every insurance company. There are some cases that might be
applied across multiple items or a whole claim.

> Typically the co-pay, then an insurance payment and then a write off. I am
> actually currently reading in your book about Unions as Adam suggested...am
> I barking up the right tree?

A stored procedure is another solution. And, that would be my
approach.

And, I did notice that you are a competitor.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)