I have a table 'jurisdiction' with columns 'code' (string) and 'name' (string).

I have a second table 'detail' which has a column 'test' that is specified as a multi-value selectbox whose data source as 'Use values from another wpDataTable'. I've specified the 'Configure relation' to be:

Source wpDataTable: jurisdiction

Display value: name

Store value: code

So I expect that this allows me to have a multi-value selectbox available when editing column 'test' in table 'detail' and store the value(s) that is one or more  'code' value selected from the dropdown into field 'test'?

Problem 1

It appears that even if my 'code' entries are unique I must choose 'wdt_id' as the store value? If this is a limitation of the system then I understand (but it is not very flexible).

Problem 2

More worryingly when I drop and create the column 'test' and specify its type as 'multi-line selectbox' I see that the Editor Input Type is identified correctly as 'Multi-value selectbox' 

I then try to set up the values for the column as a foreign key by clicking on 'Configure Relation' and at this point the 'Use values from another wpDataTable' dialog appear with a spinning circle and never stops - which I believe to be a bug.
This does not happen if I specify a list of values rather than a table (but this is not what I want)

I have now spent nearly two days trying to figure Problem 2 out and would really appreciate some help or a refund.

Many thanks

Alan Simmonds