Please Advice

[Dib]

Hi,

I am trying to design a Pricing table(s).

I have a product that has sub product. and sometimes the sub product has a
sub product.


each product or sub product has a price, but if one order more than one
product or sub product they can get a discount based on how many ordered.

I am not sure where to start.

Please advice.
Thanks
Dib

 

[Bruce]

Do not think about designing a table, think about designing a database. I
don't know what you mean by a product having a subproduct, but I can tell you
that product and subproduct almost surely need to be separate tables. You
should define just what you need to do in order to get the most helpful
suggestions.

 

[Dib]

Thanks
Dib

Do not think about designing a table, think about designing a database. I
don't know what you mean by a product having a subproduct, but I can tell you
that product and subproduct almost surely need to be separate tables. You
should define just what you need to do in order to get the most helpful
suggestions.