two one-to-one relations between two tables

Ricardo Strausz <[email protected]> Fri, 1 Aug 2003 19:35:45 -0500
Newsgroups gmane.comp.web.webobjects.eof
Message-ID <[email protected]>
Hola tod@s!

I was presented today with a modeling problem which is giving me rounds 
on my head...

Two tables: Customers and Salesmen
Each customer has associated two DIFFERENT salesman: current and 
previous.
The names of the salesmen are stored ONLY in the Salesmen table and I 
need to report them, by customer... to flatten the atributes was the 
first response, but....
If I build a one-to-one relation from Customers to Salesmen (connecting 
Customer.salesman to Salesmen.folio ---or ID if you prefere), EOModeler 
prevents me to add another one-to-one relation to connect 
Customer.previousSalesman to Salesmen.folio...

I can understand why EOModeler does it, but I had not been able to 
figure out a solution...

I know, it's friday night, but hope someone will be able to help us 
with this one.

De antemano gracias,


Dino
http://homepage.mac.com/strausz