[libreoffice-users] Re: LibreOffice base - cannot make a convenient form to add data

Am 08.08.2011 09:03, 3flight wrote:
> But I do it manually (i.e. via form editor - right click on column - change
> to listbox, then go open it's options and set it to take values from a
> linked table's second field). Can't see where in the Form Creation Wizard
> there is an option to change columns to listbox. Which wizard are you
> reffering to?

Ignore all those wizards in Base. Most of them are misleading and time 
consuming.
Draw your box or choose ReplaceWith>Listbox from another control's 
context menu. In the latter case you have to set property "Drop Down" on 
the general properties tab or you have to drag it taller for a 
multi-line box.
Properties on tab "Data" can be as simple as this:
Data field: The foreign key to be written (ArticleID or something)
Source type: SQL
Source: SELECT "Visible Field", "Primary Key" FROM "Other Table" ORDER 
BY "Visible Field"
Bound Field: 1 (which is the second field, 0 is th index of the visible one)
Source may be also a concatenation like:
SELECT "ZIP"||' '||"City" AS "Visible Field", "Primary Key"
FROM "Other Table"
ORDER BY "Visible Field"

[Example] Relations reflected by list boxes in forms:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=40444


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted