table design

[wdverner]

Hi all,
just wanted to check something with the design of a DB.

I have a PRODUCTS table which lists a product:

ProductID
CustomerID
ProductID
ProductImage

The product is made up of many components, COMPONENTS table
ComponentID
Description
ProductID

I also have a table that lists the COST PRICE for each component:

ComponentID
CostPrice

There is a 1 to M relationship between the PRODUCTS and COMPONENTS table, and a 1 to 1 between the COMPONENTS and COST PRICE table.

Now what I want to do is this...

each component can be sold seperately. BUT the prices are not the same for each customer- they are all different.

How can I create this in the table?

many thanks, its quite a head scratcher!

 

[PHV]

Perhaps a table like this:
ComponentID
CustomerID
ComponentPrice

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wdverner]

thats what i have I was just checking to see what other minds came up with! i think that sthe best way forward?