Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

On 01/11/2013 09:46 PM, Girvin R. Herr wrote:
I am using LO for Linux. I am trying to set a default entry for a listbox based on a joined table. The listbox has entries from the joined table as options. One of those options is the character: - (dash). I would like this option to be used whenever I do not set the listbox, rather than Base using NULL. I am working in the listbox control's "Properties-listbox" dialog, "Default selection" box. If I enter -, it gets changed to "0". If I enter "-", it gets changed to ""-"". I don't think either of these are what I want. There is a continuation box ([...]) to the right of the Default selection box, but this icon does not seem to do anything. The key number for the dash entry in the table is 1. So, I tried entering 1 as the default selection, which resulted in "1". I don't think this is what I want either. How do I get the default entry I want in this listbox control?
Is it possible?
Girvin Herr

Finally, some success with this problem. I worked with only two tables so it might not work with a joined table. To make this work, both tables have to be edited. Field A of Table B has the list box. Field C of Table D provides the entries for the list box. The default value desired for the list box is the dash character (-). I edited Table B making the dash character the default value for Field A. I also entered the dash character in Field C of Table D.


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.