I have a Microsoft Access table called `calc1`

with fields:

`calc_ID`

(primary key, number)`calc`

(text)

I have another table called `res1`

with:

`res_ID`

(primary key)`calc_ID`

(number)`dimensionbefore`

(number)`dimensionafter`

(number)`result`

(calculated)

There is a relation, one `calc1`

to many `res1`

, linking with `calc_ID`

.

Is it possible to make the `result`

field take its formula from the `calc`

field in the `calc1`

table?

Example:
For elongation the field `calc`

is

```
([dimensionafter] - [dimensionbefore]) / ([dimensionbefore] * 100)
```

and `calc_ID`

is 1.
In the `res1`

table if the `calc_ID`

is 1 then the result field would take the text from `calc`

and make it its formula and return the result.