Ask Your Question

Multiple Select from DropDown List [closed]

asked 2015-11-20 02:06:08 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Greetings and than you in advance for any and all assistance.

This seems (hopefully) to be an easy question - is it possible in Libre Base from to make multiple selections on a drop down list?

I have a db with two tables - Plants and Benefits the two are linked by the Benefit Id - no problem creating the drop down list - that is created and functioning. The properties on the field has Multiselections set to 'YES.' That does not seem to provide the option to select multiple list entries for the Plant...

Any and all assistance is greatly appreciated. If more information is required, please let me know.



edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by wildblue
close date 2017-12-18 00:20:02.657102

2 Answers

Sort by » oldest newest most voted

answered 2015-11-26 10:07:53 +0200

pierre-yves samyn gravatar image

updated 2015-11-27 10:18:15 +0200


In my opinion multi-selection works as it has always done: only for non-data fields controls (Data Field property empty).

This makes sense to me: how to store in a field (single-valued) a selection List?

The screenshot shows that the multi-select works and that selection can be used by macro.

image description

I understand you wish to record multiple benefits for a plant. In a relational environment this it manages by a dedicated table (a plant can have several benefits and a benefit can be made by several plants).


I gave an example implementing the multi-selection in this answer


edit flag offensive delete link more


the example is sensible and straightforward, an excellent description of how the multi-selection feature should work on its own, without macros, were it properly functional.

doug gravatar imagedoug ( 2015-11-27 15:28:16 +0200 )edit

@doug - In this case one should add the "reverse" function: select in the list the items stored in the bound field. Thank you...

pierre-yves samyn gravatar imagepierre-yves samyn ( 2015-11-27 17:40:13 +0200 )edit

answered 2015-11-26 01:21:38 +0200

doug gravatar image

Sorry to say, it's broken, as you see.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-11-20 02:06:08 +0200

Seen: 3,187 times

Last updated: Nov 27 '15