Hi!
Sorry, it's not easy, english is not my motherlanguage
Simplified:
I have a table in the database which consists of ID and Name - Pairs, for example:
ID | NAME
1 | Home
2 | Work
3 | School
And i have a 2nd Table with a field "Location". In that field the ID of the location should be saved. So if there is a "1" in that field, the app should replace that later with "Home". So far, this is no Problem at all. But: I would like to store up to n IDs in that field, So maybe "1" and "3". And then they should be replaced by "Home", "School".
I tried now to achieve that this way:
Store the IDs as String in the Location-Field: "1, 2". Then I use regex to divide the entrys and load them in a list. But I'm not sure, if that is the best way...
Best regards!