In my grid (inline editable), I have a column that, when edited will become a multi-select. The dataSource for the multi-select will be retrieved from the server and will be in the form id/text, where id is an int, and text is a string. The mult-select works great and retrieves the data great from the server. The issue becomes when I want to display the selected items to the user when the user is finished editing. The DB wants the selections as a CSV of IDs. The UI wants the selections presented to the user as a CSV of Text.
When I add a new row, the multi-select works great because there are no items to pre-select.
When I edit a row that already has selections that need to be pre-selected, how can I do this since there may be duplicate Text, but never duplicate IDs
So, 2 main issues:
1. When finished editing a row, how do I get the UI to present CSV of Text, but send a CSV of IDs to the DB
2. When populating the grid, the DB is currently sending the CSV of Text, which isn't in a good form to edit in a multi-select. I'm thinking I should include another member in the Schema / Model that is simple the CSV of IDs. How do I present to the user the CSV of Text, but when editing, use the CSV of IDs to pre-select the control?