How to change category display

I have followed the tutorial and applied to my own project. When building an admin site using WA Data Assist on the Item Detail page it displays the category as 1 or 2 for Music or Gear from tutorial. How can I change it so that it displays the name rather than the ID so rather than 1 or 2 it would show Music or Gear.

Thanks

You would update your recordset on that page and add an INNER JOIN in the FROM clause. This would allow you to look up other information based on the stored ID, including the name, and display it on the page.

Originally Said By: Ray Borduin

  You would update your recordset on that page and add an INNER JOIN in the FROM clause. This would allow you to look up other information based on the stored ID, including the name, and display it on the page.  

Not sure how to do that or what you mena by that, could you explain further or provide an example of what you mean and how to accomplish.

thanks

I did a quick google search on SQL Join tutorial... this one looks pretty good:

?action=viewTutorial&id=69

I'll take a look and see if I can figure it out, I'll let you know if I have any further questions. I assume that this will apply access and asp, not just php and mysql

Yes. You just edit the recordset from the server behaviors window. The user experience and SQL code are the same.