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