External Database - Connect multi-select

Question

I'm using the external Database to sync a lot of records that can change. 
 I've got one set where Part A can go onto Models 1 - 10. 
 I've got my model ObjectIDs set to: 1-1 1-2 1-3 ... 1-10 
 
 For Part A. Has the multi-select Field Models. I know how to add 1 entry to it with the model-ID Is there the possibility to have the multi-select host links to values 1-10? Would I need to adjust the SQL to provide a ModelID of: 
 {1-1,1-2,1-3,...,1-10} or just 1-1,1-2,1-3,...,1-10 
 The end goal is for the External Connection to update these records: Or would there be some other way to split the field to have an entry from my Relational Database provide all the models that an item is related to? Or would this be an exercise in running a periodic script to go update all these values and place them inside the ModelID multi-select? I hope that is clear enough, 
 Thanks in advance!

Joonas Linkola · Accepted Answer

You have at least these options: 
 
 Store the values on multiple rows in the external database, one value per row, like Dorean suggested. The user guide has an example of this in the note in step 22: https://userguide.m-files.com/user-guide/latest/eng/Connection_to_external_database.html 
 Store the values with a delimiter, for instance "1-1;1-2;1-3" like you said, and map this column to a text property in the object type settings. Then use an event handler script to parse and split the text string and add the entries to the multi-select property. The intermediary text property can be hidden from users.

External Database - Connect multi-select

Top Replies