title: telerik grid ForeignKey binding filter
body: <p>I have a grid that displays the Orders from customers, it contains an ItemID in it.
  Now, im using the telerik grid for mvc to perform CRUD operations on the second grid, for the column of ItemID i use ForeignKey with no problems just like this code:</p>
  
  <pre><code>cols.ForeignKey(c =&gt; c.ItemID, (System.Collections.IEnumerable)ViewData["rcItems"],
                      "ItemID", "Name").Width(200).Title("Description");
  </code></pre>
  
  <p>Now my problem was everytime i perform an edit, ALL of the Items will be shown from the dropdown. what i wanted was display only the items available that will depend on the customer on the grid. In other words, customer1 may only get(100, 101), customer2(100) and customer3(102, 103)</p>
  
  <p>I have two tables CustomerOrders and DeliveredItemstoCustomers</p>
  
  <pre><code>--CustomerOrders table
  CustomerID      ItemID
  1                     100
  1                     101
  2                     100
  3                     102
  3                     103
  
  --Item table
  ItemID   Name
  100      Apple
  101      Orange
  102      Banana
  103      Grapes
  
  --DeliveredItemstoCustomers Table
  CustomerID      ItemID
  1                     101
  3                     103
  
  --How I load the Items to Viewdata
  ViewData["rcItems"] = db.Items.ToList();
  </code></pre>
  
  <p>Basically, i want to prevent the user to enter an item not available for the selected user. I'm trying to change the Viewdata on client side using ajax, but no luck</p>
  
  <p>Thanks</p>