Changing values based on a field

[Podder]

Hi,


i have a products table with a field of unit price and a reps table that has a list of reps names.
what I want to know is, can I change the unit price of products when a certain reps name is used on a form?

[orange]

I'm sure you could, but the bigger question is "what is the logic for having a different product price based on Rep"?
Perhaps you could describe the situation and provide a sample to clarify.

[Podder]

I'm sure you could, but the bigger question is "what is the logic for having a different product price based on Rep"?
Perhaps you could describe the situation and provide a sample to clarify.

Orange,
The logic is that the Rep is in a different country and as such their prices are a percentage higher.
I have created forms associated with customers and orders which then go to an Invoice report. All works well but the only way I can have different prices is by having two seperate products and values on the products table (this is done by the use of ProductID being different for the same product).
From this I was just wondering if there was a way to create an increased price when associated with the one rep.

[June7]

So the price should really be associated with country. No matter how you associate the data, will need multiple product records. Unless you calculate the price by adding or subtracting a percentage.