Combining Multiple Database Customer Tables

[kobra]

Are these variations added as attributes??

Hard copy versus online

[abcschooldr]

No, they are individual products.

[abcschooldr]

I see what you are saying. It is the products_id in the products_attributes table that is all 4's because they all have the same attributes. It isn't making reference to the id associated with the product itself.

[abcschooldr]

So there isn't a table that lists both the product id ordered and the name of the person who ordered it. There is only a name associated with an order id, not a product id ordered.

[abcschooldr]

Maybe this is a stretch....but you have been very helpful. Have you heard of creating a 'view' on the database server to present the desired information as if it were on one table? Do you think this is a good question for my server host, or have you heard of anyone doing this with the Zen-cart database?

[abcschooldr]

What is the orders_products_id in the zen_orders_products table? Is that just randomly generated?