To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59052 Issue #:|59052 Summary:|unable to establish multiple relationships between |two tables. Component:|Database access Version:|OOo 2.0.1 Platform:|All URL:| OS/Version:|Windows, all Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|pitonyak
------- Additional comments from [EMAIL PROTECTED] Wed Dec 7 12:58:09 -0800 2005 ------- Perhaps this should be an RFE rather than a defect, but... I found this while trying to answer a question on the oooforum. Consider a simple table with transactions TRANS: ID is an integer Now, consider a table that relates two transactions together CHARGE: ID is an integer TRANS1 TRANS2 There should be a 1-to-n relationship from TRANS1 to TRANS.ID and from TRANS2 to TRANS.ID. The GUI will not allow you to create this relationship, but it can be done if you directly modify database\script. --------------------------------------------------------------------- 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]
