To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 Issue #|92782 Summary|can set multiple relationships between two tables but |only one is actually saved Component|Database access Version|OOo 2.4.1 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|gld199
------- Additional comments from [EMAIL PROTECTED] Wed Aug 13 22:56:35 +0000 2008 ------- I have a database with several tables. If I go to Tools--Relationships, I can set single (1-n) relationships between tables with no issues. I can (since upgrading from 2.3 to 2.4) set multiple 1 to many relationships (either through trying to drag and drop a second relationship, clicking edit on the resulting error dialogue box; or by double clicking the relationships line). I can get multiple relationships to appear (I see a new line for each new relationship), however when I save and exit Relationships it discards all but the first listed relationship between any two tables. Even immediately after setting up these multiple relationships, I am able to add invalid data into all but one field in my table without getting an error message. Sure enough, if I go back into Relationships, all the extra lines have disappeared and only one relationship per pair of tables is listed in the Relations editing window. [I can't see how to add an attachment otherwise I'd upload an example. I don't know what the difference is between OOo 2.4.1/RC1/RC2] --------------------------------------------------------------------- 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]
