two one-to-one relations between two tables
two one-to-one relations between two tables
- Subject: two one-to-one relations between two tables
- From: Ricardo Strausz <email@hidden>
- Date: Fri, 1 Aug 2003 19:35:45 -0500
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
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.