Hi there,

I have made a little order program.
There a 4 tables
1. Products
2. Clients
3. Order
4. Order_detail

I can make a new oder in a form. In a subform (Order-detail) I can add product to the order. In a pull down menu I choose a produkt then I fill in the amount. Then the price will be calculated.
It works perfect but....I have some produkt that have 2 prices. How can I choose what price should be calculated ?
Can anybody help me.
Please let me know if you need more information.

Same product 2 prices!! Treat them as individual products ie Biro(A) Biro(B)

That is not an option. All the product can be uploaded to internet. And if a have to use two product then a have double work with updating product. There must be an other way.
If I choose a product from the list alls field will be updated also the 2 price fields. What if I put 2 checkboxes with the prices and choose what price should be used. That was my plan but how can I realise that ?

There must be something that distinguishes the products or there would not be two prices. I do a lot of catalog shopping and whenever there is a price difference (s,m,l = $10 and xl = $12), there are two different product numbers.

there is a price for a product when you buy 1 m2 and a price when you buy a hole plate ( 6 m2) Then you get a "special price".
The reason why its one product is that I have to update double as much product when there is a change. I think thaat if somebody else in our companie is changing product it will be a mess.