Filter Listgrid data depending on entered value in another cell

[zaj]

Hello there,

I have a listgrid which has 4 columns. Code,Name,Qty and Price. the name cell is a Combo Box which loads the names via datasource. So far all is fine. now i want to be able to enter a code in the Code col cell and then i want the Combo box to display the name in the Name cell and the corresponding Price in the Price cell. Can somebody help me to achieve this.

cheers
Zolf

[zaj]

anybody to help me

[zaj]

I am trying something on this line. But no luck.

codeField is ListGridField and productSelectItem is populated from datasource from database and is a Combobox

codeField.addEditorExitHandler(new EditorExitHandler()
		{
			
			@Override
			public void onEditorExit(EditorExitEvent event)
			{
				System.out.println(event.getNewValue());
				
				Integer id = Integer.valueOf((String) event.getNewValue());
				Criteria criteria = new Criteria();
				criteria.addCriteria("productCode", id);
				
				System.out.println(criteria.getValues());
				productSelectItem.setPickListCriteria(criteria);
				//productSelectItem.getPickListCriteria();
			}
		});