I have a two tables, floor and building.

In floor, I have a field called "name" that is calculated by:

name = floor::number & " Floor - " & building::name

I need this combined field when I specify where rooms are.

It works great when I make a new floor, but if I change a building name, it does not recalculate.

I read about creating a script which recommits each record, but is it really that complex?

-Jeff

Edited December 17, 200718 yr by Guest

You need to redefine this field from a Text field with an Auto Enter calculation to a Calculation field with a Text result.

Thanks!!

-Jeff

"but if I change a building name, it does not recalculate."

but ... one table can't see the other when a value is changed. If you aren't using an unstored calc, I don't believe it will know to change no matter HOW you apply an auto-enter calculation.