indexing

I am trying to create a lookup column in an index table that can give me values from a query when I click on a field. I am unable to make the lookup work properly… could anybody tell me how exactly the query must be structured?