Saving more than one value from multiple drop down menu
I have a form that posts values from a multiple selection drop down menu. I am using SQL DB.
I am trying to figure out what is the best way to save those selections.
the options on the drop down menu are:
Text | Value
Approved | 1
Closed | 2
Pending | 3
Expired | 4
User can make more than one selection, and the values would end up being something like: 1,3,4
I can save those comma separated values into a nvarchar field for example. If I do this how can I then retrieve them to show those values in the edit page, so that the drop down menu shows all the selections that were made ? If I pass 1,3,4 will the drop down menu shows all those selections highlighted and understand the commas are separating each value ? Do I need to retrieve the values with a specific query ?
I haven't done this so far so I apologize if it sounds like a silly question.
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.