Hi I am new,
Nice forum.
I want to make a basic small business database.
Customers stay the same yet each customer has a different price, it also depends on product.
Say one customer may be charged a different price for the same product as another.
Yes prices are negotiated, supply and demand, quantity,, etc.
So I need the historical prices to stay the same if customer negotiates a different price mid month.
So when boss wants a statement it will reflect the prices at that time.
Pretty much I do not want historical prices to change, lets face it if price changes mid month and the updated price updates older entries, it will be a useless monthly, yearly statement.
Cheers