Re: Multiple Prices for same product

I would probably do it something like this:

Company
=========
CompanyID
CompanyDesc
CompanyPriceLevel
Companyetc.

Product
========
ProductID
ProductDesc
ProductEtc.


We'll assume that product prices can change over time and that you'll want
to retain an accurate view of what the prices were.

PriceLevelProductDates
===========
PriceLevelDateID
PriceLevel
PriceLevelBeginDate
PriceLevelEndDate
ProductID
Price

If all prices change at once, you would want to have a different structure,
so you didn't have to enter begin/end dates for each and every product. You
also could assume that when a new price level begins the old is superseded.
That makes the queries harder, but prevents dead times with no price and
overlaps.

HTH;

Amy

"ashlanddave" <ashlanddave@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:59FD6FBE-DFC8-4BB7-82DD-D44F6747EABC@xxxxxxxxxxxxxxxx
Hi Amy,

The prices are random, unfortunately




"Amy Blankenship" wrote:

Are the price levels pretty much random, or is there a mathematical
relationship... For example, would level 2 be level 1 * 1.5 and level 3
be
level 1 * 2, etc.?

"ashlanddave" <ashlanddave@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3837E998-72B7-489A-BC8A-8239D0D595D3@xxxxxxxxxxxxxxxx
Hello World! I am working on a dbase for sales order entry (like
template)
and need to have different price levels or prices (eg. 3 levels) for
the
same
product. Each company has an entire pricing level assigned to them
(either
level 1,2 or 3). How do I set up the diffent pricing levels? I have a
table
for customers, orders, order details and parts.





.

Loading