Finding the link for category

[keepingbusy]

Hi

I have been able to download the products and products_description structure via MySQL to create our own self-populating lists using a Visual FoxPro application and upload them back succesfully.

We have two categories set up called CD & DVD (there are no sub categories to make it easier).

My question is: Where is the link or code number that tells the table that the title (e.g. Bryan Adams Greatest Hits) is a CD?

I have found a table called categories_descriptions that lists CD as categories_id 21 and DVD as categories_id 3 but I cannot find any reference to these in the above two tables I have mentioned.

Many thanks

Lee

Windows XP
Visual FoxPro Version 6 & 9

 

[keepingbusy]

Cancel the last, the table is called products_to_categories if anyone needs to know

Lee

Windows XP
Visual FoxPro Version 6 & 9