Subject Calculated fields vs Computed By fields
I am used to using Calculated fields with TTables. This worked fine
with Paradox but obviously isn't the best way to use IB. I am now
converting any Calculated fields to Computed By fields. However the
problem is that computed by fields are only computed when the table
is refreshed.

Is there a more efficient way of forcing Computed By fields to
display other than issuing a Refresh? Or is there a better solution?

In addition, what is the best way to create a 'lookup' field. ie a
computed by field that gets its value from another table?

Any help would be appreciated.