View Single Post
  #4  
Old January 31st, 2010, 04:19 PM posted to microsoft.public.access.tablesdbdesign
Blinds Nottingham
external usenet poster
 
Posts: 6
Default How to design a table or table to take an x, y control columnsand all the possible array values

Hi
thanks for replying so quickly

I can show you what i mean in an excel format but looking at trying to
convert this to a database so i can do lookup etc on prices dependant
on product and width and drop sizes

there is the idea of 3 blinds, 2 the same type but from different
suppliers, who have different size for the prices and increments so to
show that nothing is standard

then an example of a roller blind .. prices are fictitious but
eventually want to enter a cost price and then have access or vb
dynamically create the end results.. i am a noobie really to this as a
developer, but have sorted many database and systems.. done alot of
vba in excel and some in access

hope this makes things a bit clearer

http://www.bradrail.co.uk/uploads/pr...istexample.xls
and thanks again