auto-updated fields in tables...

[nale]

Hi all, beginner question:

How can I set up a field in a record to do automatic calcuations?

For example, I have a table with products and prices in different
currencies:

---------------------------------------------------------------------
ProductID -- Product name -- Price USD -- Price GBP -- Price Euros
---------------------------------------------------------------------


What I want to do is to fill just the prices in dollars (USD) and the
other fiels to be automatically converted to pounds and euro, doing
some calculation with the field in USD...How can I do that?

Best regards

 

[nale]

can be done using macros, or VB code? how???

nal

 

[Rick Brandt]

can be done using macros, or VB code? how???

You can only do something like this in a form, not a table. In the AfterUpdate
event of the dollars control you would run code to calculate the other values
and populate those controls.