To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101463 Issue #|101463 Summary|form wizard: creating a sub form from an existing rela |tionship does not work for MySQL/JDBC Component|Database access Version|OOo 3.1 RC2 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|lla Reported by|fs
------- Additional comments from [email protected] Thu Apr 30 20:05:02 +0000 2009 ------- - import the attached database script into a MySQL server. It will create a database having the number of this issue, two tables "names" and "details" in this database, and populate them with some sample data - in OOo, create a database document connecting to this MySQL, using JDBC - for this database, start the form wizard - on the first page, select the "names" table, and all fields, and proceed - on the second page ("Set up a subform"): - check "Add Subform" - check "Subform based on an existing relation" - select the "details" table - finish the wizard with all other settings defaulted => the newly created form is opened - travel through the records of the main form => in the details form, *all* records are shown permanently. Expected result is that only those records are shown which belong to the currently-active main form record - close the form - open the form in design mode - open the Form Navigator - open the property browser for the "SubForm" form from within the Form Navigator - switch to the "Data" tab page in the property browser => the fields "Link master fields" and "Link detail fields" are empty. If they would contain names of the fields which define the relation between the two tables, then everything would be okay So it seems the problem here is that the wizard does not properly retrieve the fields which make up the relation between the two tables. Something which works perfectly when you do the whole thing with a HSQLDB database ... --------------------------------------------------------------------- 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]
