I am developing a display catalogue for a promotional item print company.
The information is very complex and sortting it out into tables is a bit intrikit. my major hurdle is the prices of an item
the following factors contribute to the items price
each item has a price range e.g.
However , the ranges may differ e.g.10-$10.00, 20-$10.00 etc.
and they depend on the productanother pdouct may have 100-$10.00,200-10.00
further to this a product may have a 2 sets of ranges based on a option e.g.
and again the option may vary1 colour - 10-$100.00, 20-$200.00
2 colour - 100-$1000.00, 20-$2000.00
Now i am thinking of defing a price_list column to help separate the prices and use columned ranges. but i am still pose with the option of having duplicate entries and the different ranges.
my second option would be to make an attribute table and just have them enter an attribute => value as the product catalogue contains varying attributes e.g.
this will allow them to specify the aring price ranges in this area.some products have a "print area" attribute other have a suggest colour attribute
i having a hard time deciding you advice is greatly appreaciated.
Kendall
the forum profile says i am a professional!!?? Im a professional? I thought i was me...a trinidadian...lol