RE: Multi tables having a to-many relationship to the same table

Thanks for the 00 guidance.  Your advice prompted me to read the
Modeling Inheritance section of my 'EOF Developer's Guide' book for a
refresher on OOing my RDB.  I think I can take it from here. Thanks
again.
JohnR


Here's how it can work.

Create an abstract entity "HistorySupport". Let it have a primary  
key. Join along this primary key a toMany relationship to your  
"ChangeHistory".
Subclass all entities, that should have a history from  
"HistorySupport." They consequently must all use that inherited  
primary key. So give it a generic name like "idR" and not schoolID.

Let EOF do the rest.

Ciao
    Nat!

      Jedenfalls sind zehn Fehlstarts hintereinander    [E. Fuchs]
           ein sehr interessanter Beweis
               fuer unsere Theorie
  von der natuerlichen Ueberlegenheit des Dezimalsystems

_______________________________________________
EOF mailing list
[email protected]
http://www.omnigroup.com/mailman/listinfo/eof