Please Advice

  • Thread starter Thread starter Dib
  • Start date Start date
D

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
 
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.
 
Thanks
Dib

Bruce said:
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.
Click to expand...
 
Back
Top