I have a vb programme.there I link it to a access database.In the database I have a table with 3 fields code,description,amount.I used primary indexing for code field.so codes are as 1,2,3,4,...when I enter the code number in vb program I can extract related description and amount.but what I want is to change the indexing numbers equal to another word.that means 1=banana,2=mango,3=apple... so I can enter word banana instad of code number 1 to extract related description and amount.please someone tell me how can I do that??

You need to store thsoe informations in a separate table and pass the value to the outer query by fetching from inner query.

thak you very much !!