To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109034 Issue #|109034 Summary|Second Listbox in table control shows ID instead of te |xt Component|Database access Version|OOo 3.2 RC5 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|cascabel
------- Additional comments from casca...@openoffice.org Sun Feb 7 19:44:38 +0000 2010 ------- OS: Windows XP SP3 OOo 3.2 Release Candidate 5 Create a main table (say Table0) with primary-key + two fields linked to primary-keys in other two tables (Table1,Table2). Design a form with a table control. Datasource=Table0. Add two listbox columns in the ID-Text way (SELECT "Text","Id" FROM "Table"). Insert some records on tables. Open the form. First column shows text from Table1 pointed by ID value recorded in Table0. Second column shows ID value instead of Text. Click on IDs of the second column. The ID value is replaced with the (correct) text. Leave some records showing IDs up in the table. Scroll down the table. The not-yet-visible records appear showing text. OK. Scroll back up the table. The formerly wrong records now show correct text instead of ID. New records inserted are correctly displayed. Expected: The second column should act the same way as the first one. The table should show text from the start, not IDs. Attaching sample file with data. Open MainForm and test. --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org