Can someone please help or put me in contact with some help files, I'm a very new user to Dreamweaver Ultradev.
I'm creating an online catalogue and have various field eg: category; manufacturer; group; vehicle.

These fields are seperate tables and you select them from a drop down list in the product table in my database.

The problem is the searches are working correctly but when I display the product details on the result list page and detail page it is displaying the ID of these items for the product and not the label.

EG:
Part Number: test
Product Name: test
Description: test
Category: 1
Manufacturer: 21
- I want the name "test category to be displayed"
- I want the name "test manufacturer to be displayed"


How do I change it to display the label and not the ID.

Can someone please help me ?

I think your problem is that you are pulling the results from your product table and the product table only holds the link id to your category and manufacturer fields.

You need to create join your tables in order to get the test category name to be displayed.

Can you tell me the following so I can write the sql for you:

What does your recordset sql look like now (post it here)

What db are you using (access eg)

What are the names of your tables (product, cat and manufacturer) and what are the field names.





Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting