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.

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?

> Are the tables meant to be related to each other in any way?
> or are you just interested in "all of the billings and all of
> the payments, arranged in ascending order by date" ?
>
> ./heLen
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources
> item on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>