Not displaying anything
Jason - thanks for the detailed instructions. That was an extremely helpful "how to" that will now be in my "help pages".
I made the changes and it gave me an "Undefined Index . . ." I added a line to suppress error handling and that obviously got rid of the error. However, now I do not get any results at all in my "Category" column.
I hit the "test" button in the server behavior and it and both tables were indeed combined into one - all columns present.
It appears that the line <?php echo($row_WADAitem['itemcategory.ItemCatName']); ?> isn't pulling up the ItemCatName.
Any additional suggestion - (I know it's close because the inner join is working - it's producing the new table . . .)