title: Update Table Column using Combobox or dropdown
body: <p>Hi I'm trying to update a column using a Combobox, What I'm trying to do is when you select the year it updates the user column with that year, the concept it to have multiple years with different users I would really love to hear if you have a different way to solve this I'm using MVC and devexpress</p>
  
  <p>What I have done so far is I have the year id in both tables with a foreign key attached which is working now I want to switch between years or id's to the whole app so they can enter multiple years of data and filter using the dropdown instead of regular devexpress filters,</p>
  
  <p><a href="https://i.stack.imgur.com/cUkBG.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cUkBG.jpg" alt="enter image description here"></a></p>
  
  <p>--------------------------------------------- Edit <br/><br/>
  Should been more specific here is my database structure, 
  <a href="https://i.stack.imgur.com/uwmBu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uwmBu.png" alt="enter image description here"></a></p>
  
  <p>So what I have so far is the data under benefits table change with the selected year table when member year id = member benefits id, so what I'm trying to do is just update the member id when you select a different year so I can add more benefits to the same user. <br /><br /> Thank you in advance.</p>