Hello,

I have set up a category list in DBMan but now need to reference each category to a particular ID from the database for the search function. As an example if someone picks lets say 'productA' from the category list box on the search page I would like the search function to match 'productA' with it's corresponding ID of ProdA from the column in the db and show all corresponding items from the db that start with ProdA which represents all related products for productA that are in the database.

Thank you for any help.

Richard
Cheers!

Richard

I can think of 2 things that might help you.

1. Use the categories MOD to examine the ProdA field, knowing there are multiple records which begin with the same 5 characters, trim off the everything else, then let the categories MOD examines it.

for example;

ProdA-part1
ProdA-part2
ProdA-part3

will all be grouped into ProdA and the search link created (using ProdA* as the search term) returns -parts1 to -part3.

Idea #2 I think does not apply, but I use the Categories MOd to examine more than 1 field at a time. I even recall there was a categories with sub categories MOD, which I guess is what you need.