I posted this on microsoft.public.access - then realized that this was
a more appropriate group.
--------------------------------------------------------

Muni bonds.

Accounts within accounts.... sort of.

Somebody buys 150 mil of XYZ into account A

Trade ticket for 150 mil goes to fund accounting and we need to know
that's where the money is.

BUT: at the time of the trade, the trader allocates 50 mil of 150 to
account D as XYZ, 75 mil to account F as XYZ, and 25 mil to account M
- also as XYZ.

Now XYZ's 150 mil is in the DB twice: a lump in account A and three
pieces in accounts D, F, and M.

But we need to report on accounts A, D, F, and M the same way. i.e.
they are co-equals for reporting purposes.

Doesn't seem like a parent-child relationship.

But what is it?

Some sort of recursive relationship?


I've *really* got to get this one right.

Anybody been here?