How to change category display

[pdesignz]

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

[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.

[pdesignz]

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

[Ray Borduin]

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

http://www.dreamdealer.nl/?action=viewTutorial&id=69

[pdesignz]

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

[Ray Borduin]

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