Hi 

I'd like to have a multi-select dropdown field (Say in Table A) that is sourced from another table (Table B). This option does not seem possible, but it is possible with a predefined list. 

I'd like my users to be able to update/add to update Table B so that the option for the associated column in Table A get the new values - how can this be done?

Many thanks

Alan

Thanks Aleksander

I do use the foreign keys option to collect data from table B to insert into table A, however I can only ever select 1 value at a time, I'd like to have a multiselect dropdown of table B items available to update to a string column in table A. E.g. I need a list of countries where a process X takes place - so process X could have several countries such as France, Germany, Italy etc. At the moment the only option I have it to ad in one value from table B.

Here's how I set up the column in Table A

But when I try to change the option to multiselect it is greyed out:

Any help would be much appreciated.

Thanks

Alan

Hello Alan,

this sounds a bit similar to my old problem.

https://tmsplugins.ticksy.com/ticket/2944273/

From my point of view, this doesn't work with my multiselect box. I need to work with the Value List in each table.
This always requires maintenance when a new value is added.

But I'm curious, maybe exist already a better solution.

Best regards
Jens

Hi Aleksander, Jens

Thanks for your replies.

Jens - this is something I've had a look at, but the problem is that I'd like my users to be able to update the list as well. This would then provide a much richer picture, without admin help, for other users to make use of. Having a predefined list is ok in a few cases but not when that list needs to be dynamically updated, or at least added to.

If you know of a way to dynamically update the 'Possible values for column' list I would be very interested.

Many thanks

Alan