To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108099 Issue #|108099 Summary|listbox column in grid control bound to other tables/s |ql does not work properly Component|Database access Version|OOO320m7 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|eberlein
------- Additional comments from [email protected] Wed Jan 6 08:24:37 +0000 2010 ------- see attached doc: open form in edit mode, toggle to live mode. There are relations between the id's of table_fk1 and table_fk2 to the main table of the form. Columns 4 and 5 are formatted as listboxes, bound to table_fk1 and table_fk2. The difference is that in the table_fk1 the text value is in column 2, but in table_fk2 is in column 1. So the bound field value in column 4 is set to 2, in column 5 to 1 (the help pages suggest to use value 0 for the first column, which is IMO wrong). What should happen: The values of the text column should be displayed in both columns. What happens: The values of the id is shown in column 4, column 5 is correct. Toggle to edit mode and check the settings of the columns. Columns 6 and 7 are formatted as listboxes, bound to sql select command of table_fk1 and table_fk2. What should happen: columns should show the text values of the corresponding tables table_fk1 and table_fk2. What happens: The id's are shown. --------------------------------------------------------------------- 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]
