Code created by wizard needs tweaking?

Hi everyone,

I've created a set of pages for an administrative backend using the DataAssist Wizard. Among the pages created by the wizard is a results page which was supposed to display two things: 1) the name of the subcategories that are listed in the subcats table in the database and 2) the name of the related category. It displays the subcategory correctly but instead of displaying the category name, it's displaying the foreign key, eg.

{WADASubcats.SubcatCategoryID}

The wizard was working with my subcategories table when it created the pages so I wondered if this is why it's not displaying the category correctly, since the category name is listed in another table in the database.

Can someone tell me how to fix this problem? Did I take a wrong step when running through the wizard or do I have to manually fix this after having run the wizard. If yes, how would I do this?

I also noticed that the insert page that the wizard created correctly inserts data into the correct table in my database but the code created doesn't seem to block duplicates from being entered. Is this something that I have to fix manually or was there something I missed in the wizard that could have prevented this?

Appreciate any assistance.