On Feb 4, 2007, at 10:01 AM, Michele Olson wrote:
How is the storage set for the field?
Do not store calculation results. Recalculate when needed.
For calculations, check Storage Options when in the Specify
Calculation dialog.
If Indexing is on with build as needed, they will auto re-calc. If
global or no indexing with no build as needed, the calc is
performed the when the record is created and not again.
This is probably the problem. I have the logo's stored in a different
table called Functions in a field with multiple repetitions. This
table is related by a constant so that all fields are available to
all tables. This is left over from a multi file database. I'm going
to try storing the logo in the same file.
For standard fields: Options -> Storage tab.
Same info about indexing as above.
What is the relationship Functions?
A table to store info that I wanted available to all other tables.
Related to the other tables by a global constant.
What are key (match) fields?
A global constant
Are they the same type?
Yes
And of course, the first question should have been: what version FM
and what OS?
FM 8.5 - OS 10.4.8
M.
-----------------------------------------------------------
Judith Foldi
Things never were the way they used to be
