Support match tables

[mattbrailsford]

Currently when you use checkbox lists or multi select list, the values are stored as a comma separated string. Would be good if we could some how support match tables to allow better storage of these values as it makes lookups a bit difficult.

[Killerkiwi2005]

Maybe change storage to JSON

Then you can use TSQL to query the json values directly

SELECT tblTest.*
FROM tblTest
    CROSS APPLY OPENJSON( tblTest.Options, '$') x
WHERE x.value = '5';

[TimGeyssens]

@Killerkiwi2005 good idea, but not an easy task I think