Andrus,
Thanks for researching this and figuring out that the cycle is the
problem. That makes sense.
> But regardless of this limitation, I think the schema can be
> redesigned to remove the cycle. member.bill_account_id can be
> substituted with bill_account.member_id. If I understand it correctly,
> a bill_account always belongs to a single member, right? It is not
> shared by multiple people?
Unfortunately, a bill account has one or more members. Each member has
to have a bill account, but more than one can point to the same bill
account. (One member is the designated "owner" of the bill account, but
that's taken care of with another unrelated MemberRole relationship).
Jim
-- Jim Menard, jim..o.com, http://www.io.com/~jimm/ "This looks like a job for Legal Tender!" -- The Tick
This archive was generated by hypermail 2.0.0 : Thu Jan 29 2004 - 20:35:41 EST