Let's start with the following for discussion. Provide your comments and we
can modify as needed.

TblSupplier
SipplierID
supplier fields

TblProduct
ProductID
SupplierID
ProductName
MaxWidth
StartWidth
WidthIncrement
MaxDrop
StartDrop
DropIncrement

TblProductSizePrice
ProductSizePriceID
ProductID
ProductWidth
ProductDrop
Price

For data entry to TblProductSizePrice, you would use MaxWidth, StartWidth
and WidthIncrement to get the
ProductWidth entries You would use MaxDrop, StartDropand DropIncrement to
get the ProductDrop entries.

For your invoices you would use ProductSizePriceID to get the item price.

Steve





"Blinds Nottingham" wrote in
message
...
Hi

Looking for some guidance on how to design.. then manipulate a price
grid structure in a database

the first part of the project will to design a data table or tables
which i can see ideas on how to do it but not too sure the best way

Each product that is supplied has its only price table and its own
sizes always variants for each product to product

Ie Roller Blinds has a max width of 3 meters starting at 400mm then at
an increment of 200mm 400,600,800,1000 ... etc becomes the grid column
headings then the drop row heading may be 1800,2200,2600
where a vertical blind may have a max width of 5m starting at 600m and
increments of 250 thus 850,1100,1350 etc and the drop might be
400,800,1200

where i am trying to describe the constant increment in x and y value
no one product may ever be the same

then for ever width x drop there is a price making a data / look up
table / grid

i presume i could make a table which said

productid , product name, width, drop, price

is this going to be the best way... in consideration the next step is
to look how i can display a input form which can step through each of
the x and y to enter a price which make me think that the price may
need to be in a different table and linked to the width and drop .. or
is that overkill

comments welcome on concepts and ideas... also if some one know enough
about a way of creating an input grid so they user can enter width and
drop increments then show a grid with heading and column and then edit
directly the price in i would be gratefull the only grid i have seem
see to be table grids rather than an 2d array type of grid.

thanks

Nick