main logo
Subject: CBSampleDatabase:Design
Author: Farooq Aslam
Posted: 2002/01/18 01:42:52
 
View Entire Thread
New Search


Greetings to All,

While working with CB Sample Database "Gitter" provided with CB62beta, I have a question.

In the "Products" table, there is a field named "yprice", that may be used to calculate the price of a product, whereas there is no price field for any of the "Parts" used for that product. Is the "yprice" for a product going to be a factual price based on the total for all the constuient parts, or is just a random value.

If it is just a random value as long as I understand, then in order to use a factual price of all the parts,what should I do? Should I have to add another table for parts purchased or just a field named "yprice" to the parts table. I need some education on this point.

Thanks in advance
Farooq

mfaslam .AT. hotmail .D.O.T com
mfaslam@uet.edu.pk
 
©2002 Farooq Aslam
<-- Prior Message New Search Next Message -->