RadGrid displays integers instead of text for column values

[Alex]

I am using a Ajax RadGrid to display contents, however, I want to have text show up in some columns instead of numbers. I have attached a screenshot of my grid. I may have setup my database wrong, so I'd like some help trying to correct this, please. I have a primary table called "kb" which holds the values inserted from a web form. I have about a dozen AccessDataSource tags with different select statements: one for each control on the form. So if I have a drop-down called "kbcategory" I also have an AccessDataSource which is pulling from a table called "category" for all the values. So my category table would have several rows with data like (apples, bananas, pears, etc.). My insert statement to put my form data into my "kb" table pulls the "id" values from the drop-downs in the form and enters their numeric values. So all my drop-downs in my "kb" table have number listed in them. I created a pk/fk relationship between my primary table "kb" and all the other tables.

So, now I want to display my data in a grid, but I don't want to show the numeric values of the drop-down columns. I want their respective textual values: like apples or bananas. As you can see from my screenshot I am only showing numbers in the columns named "kbcategory" and "kbsubcatid".

How can I get these columns to show text instead of numbers?

Thanks in advance.

[Alex]

See this post http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28060203.html#a38975734 for a solution.

[Mitch]

Man. Links are unreliable enough as answers, but a link to experts exchange? I'm looking more closely at the question but I'm really not seeing where he's asking how to make a terrible website