To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99532 Issue #|99532 Summary|Listbox Limiting or Narrowing for form List box Component|Database access Version|1.0.0 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|voobase
------- Additional comments from [email protected] Mon Feb 23 13:26:02 +0000 2009 ------- A common question on both community forums in the "Base" section is how to design a form where the selection made in one List Box determines the available choices in another. A crash course in Basic programming is usually what follows, deterring many beginners from continuing to learn the database application. The procedure to "code around" this missing feature often requires at least a page of customized code. A worthwhile enhancement to the list box would be for this procedure to be vastly simplified. Presently the wizard associated with a list box steps the user through constructing a list box whose list is governed by a SQL statement, which can reference a table or a view. This would assure that most users would set the list box up this way rather than using a value list. By setting up two tables which have a primary key, foreign key relationship, the data structure required for a list box to limit the values in another is borne. The data can be input into these tables in the required related fashion by simply creating a form with a mainform - subform relationship. This is easily achieved when constructing forms using the "Forms Wizard". An enhancement suggestion would be that an additional pair of properties in the list box be created such that a foreign key value could be associated with a foreign key field from the data table of the listbox. This would then be used in the "WHERE" part of the SQL statement. The listbox should be able to obtain the value from either the form or the form's rowset and then execute a "refresh" when ever this value changes. For an example of the type of macro presently required, please see these postings on the forum... http://www.oooforum.org/forum/viewtopic.phtml?t=71055&postdays=0&postorder=asc&start=15 and http://www.oooforum.org/forum/viewtopic.phtml?t=74688 For an indication of the popularity of the question on the forum please go to these community forum's search field and type in listbox and Voobase as the author... http://www.oooforum.org/forum/search.phtml and http://user.services.openoffice.org/en/forum/search.php --------------------------------------------------------------------- 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]
