Autopopulate related field

[slide]

I have a table that I'm storing Horsepower and Watt in. Is there anyway to set it up so that when I provide Horsepower it automatically populates Watts? (just a simple multiplication)

 

[boblarson]

Are you creating a table that is a lookup for Horsepower and Watts? Or are you storing the same values of horsepower and wattage for multiple records? So, in other words, are you taking the values of horsepower and watts and storing them for a certain record? If so, then you really shouldn't be storing both as one can be calculated from the other. If this is the initial lookup table then you could use an update query to calculate watts from horsepower (if there is a formula - I'm not sure what it would be) and then populate that.