To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56898 Issue #:|56898 Summary:|Two separate relations for the same pair of tables |impossible to define. Component:|Database access Version:|OOo 2.0 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|emmonos
------- Additional comments from [EMAIL PROTECTED] Fri Oct 28 13:38:48 -0700 2005 ------- It is not possible to define two separate 1-n relations for the same pair of tables, i.e. table2 has two separate foreign keys referring to table1. Example: A table "Family" (table2), that includes "FatherId" and "MotherId" attribute fields, both corresponding to entries in the "Individual" table (table1). I've tried different ways using the "Relation design" window. 1. By dragging the foreign key2 of table2 into the primary key of table1, the message "relation already exists" appears, indicating that a second relation is not expected to ever be needed, which is usually correct in practice, but in principle wrong, as the example above proves. 2. By pressing the "New relation" button. This way the relation can be defined and actually two separate lines connecting the two tables appear but the previously defined relation is not enforced any more and if the "Relation design" window is closed and opened again, only the one relation is indicated by the lines drawn. MS-Access does this properly, although not ideally, by allowing the introduction in the "Relation design" window, of the same table more than once with an alias. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
