Get multiselect listbox to store calculated fields

[Rajko]

I have a coboboxwith a list of products and a multiselect listbox
"Countries". The price of the product varies (two variants) and depends of
the country being chosen. This price has its own field on form. Then it is
calculated in discount and newprice field textbox.
And here is the problem. With code behind Save Records(command button)
i can't get the other price variant. Records are filled only with one value
from textboxes.
Is there a way to get the real values.

Everything works fine if i divide countries in two listboxes where
only one price variant exists.


Thanks

 

[MacDermott]

It sounds as if you are trying to save two values in the same field.
(prices for two different countries).
This is contrary to good, normalized programming.

Perhaps you could post more detail of what you're trying to accomplish here?
- Turtle

 

[Rajko]

No. Not in the same field.
All database is based on discount. There is a product list with to fields
(ABC price and DEF price)
with different prices for each product and there is a combobox with 20
countries of witch 8 have
ABC product price 12 DEF price.When I click on one country the current price
for that country is
displayed in one textbox. And there are two textboxes where the user can
enter the discount %
on the product and a field where newprice is calculated.
Now when i select one country everythin works fine when i save the record.
But the problem is when i select more countries at a time the price and also
calculated newprice
is the same for all saved records with the price of the last clicked country
in thelistbox.

Hope this help a little bit more to understand what I want.
Thanks