Multiply Field, Results in a new field

[greg303]

I have two tables, one table has two fields with numbers, the other table has relationships with the first. I want a field in the second table to take the values of the number fields from the first table multipy them and have the result in the second tables field. How would I go about doing that?

Thanks in advance.

 

[EPT]

Generally, calculations are done in a query not a table. Are you sure you want to be storing static data in a table?