Product id used in multiple tables

[Guest]

I'm a newbie and not a programmer. I am just starting to figure out how OScommerce operates and I am confused by the table osc_products and the table products_desccription which both contain the field products_id and its auto incremented for both. How are the two records associated if they both have their own product_id? I'm very confused by this. Can someone explain the why and how this is the way it is?

thank you

[Guest]

it's a bug. In the products_description table the products_id should not be set to auto-increment. Because the products_id is the same for both tables with the products table driving this.