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: [email protected]
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
