How to update

Hello,



im having two work books in excel 2007
one work book i kept as a database with fields code item type quantity
this is havng 100 records


second workbook
when i will give the code
it will display corresponding item and quantity
we can update the quantity
when i will update the quatity of an item it must be changed in the other workbook automatically

pls help me