Hi,

I need to filter the data in grid2(Item List)/store2 based on the first (item details)grid/store

Based on my attached images,

code 41300098 is already selected and it is in item details grid...


When i need to select an another item....the code 41300098 should not be shown in Item List grid...


From another image,

code 41300098,41300099 is already selected and it is in item details grid...

now, the code 41300097 only has to be show in Item List grid...



I tried...in code behind...
StoreItem.Filter("ItemCode", "41300098", True, True)
 StoreItem.DataBind()
	
<Listeners>
      <Load Handler = "this.filter('item_code', '41300098', true, true);" Single="true"/>
</Listeners>
How can i do this..using filter with multiples of data???

Click image for larger version. 

Name:	items.JPG 
Views:	51 
Size:	18.4 KB 
ID:	5049Click image for larger version. 

Name:	item.JPG 
Views:	48 
Size:	16.6 KB 
ID:	5050