this is the code that out puts the values being returned from the recordset:
<?php echo($row_WADAitem['ItemCatID']); ?>
You need to edit the recordset select statement using the code I provided.
Go to Window -> Server Behaviors.
In the list of server behaviors, double click the WADAitem recordset to edit it.
Replace the SELECT* FROM item portion of the recordset with the SQL:
SELECT item.*, itemcategory.ItemCatName
FROM item
INNER JOIN itemcategory
ON item.ItemCatID = itemcategory.ItemCatID
then change:
<?php echo($row_WADAitem['ItemCatID']); ?>
to:
<?php echo($row_WADAitem['itemcategory.ItemCatName']); ?>