Ask Your Question
0

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.

~Respect

WildBlue

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
1

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

pierre-yves samyn gravatar image

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

Hi

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).

[EDIT]

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

Regards

edit flag offensive delete link more

Comments

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
0

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

Stats

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

Seen: 2,783 times

Last updated: Nov 27 '15