Hi,
I have a problem with pricing of items. I am writing a database for a company that sells pigeon rings and not sure hoe to go about the pricing.
They are for example:
Std rings are qty 25, 50 or 100 £8, £12 and £19 respectively
ETS Rings 25, 50 or 100 £8, £12 and £19 respectively
Singles 1-15, 1-25 or 1-50 £ 5, 9 and 13 respectively
Widow Hoods 1-15, 1-25 or 1-50 £ 5, 9 and 13 respectively
Also the price may differ and the qty's may change with each order
One other query I have is that I want the customer to be able to change the main pricing structure easily.
Just unsure the best way to go about this in tables any ideas would be grateful, any questions about this please ask And I will get back to you straight away.
Thanks
Tony