crystal report help

i have a problem in cr 8.0 when i try to link table to other one then it says not an index field . only one field that can be linked is marked green . either tell me how to make other fields as indexed or some other way out

You need to go into your database and add the index(s) where appropriate. You can also use a SQL Statement in CR to create your datasource.

sir please also tell me how to insert data into a report from a number of similar named columns that means if i have a column in my table named item and i want to add items from the table that have similar article number so the num. of items can be more than one so how to do that some loop or what please tell me