To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51787 Issue #:|51787 Summary:|Problems with creating multiple relations between |tables Component:|Database access Version:|OOo 2.0 Beta Platform:|All URL:|http://www.oooforum.org/forum/viewtopic.phtml?t=21632 OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|vreid47362
------- Additional comments from [EMAIL PROTECTED] Sun Jul 10 19:43:36 -0700 2005 ------- In OpenOffice Base it seems impossible to create relations between the same field in one table with multiple fields in a second table. Please see the attached OpenOffice forum url for the question that I posted to the group there. Here is a summary of what Base should do. I have 2 tables people and issues the people table has a field people.id that needs to be set as the foreign key on 2 field in the second table. In the second table, people.id needs to be a foreign key with a 1 to n relationship to issues.reportedby and issues.assignedto. Unfortunately, although this very common type of relationship type is possible using the SQL part of OpenOffice Base, the qui seems quite unable to accomplish this. Please create a way to create these types of relationships with OpenOffice Base. It will go a long way to making the software more usable. --------------------------------------------------------------------- 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]
