Feild based upon other table not recalculating when other table changes...

[Jeff Albro]

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, 2007 by Guest

[David Jondreau]

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

[Jeff Albro]

Thanks!!

-Jeff

[LaRetta]

"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.