On Feb 4, 2007, at 9:29 AM, Judith Foldi wrote:
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.
If the multiple repetition logo field is a global, there is no need
for the relationship Functions to display the global. Globals can be
accessed from any table without a relationship.
If related by a constant (assuming 1), do the importing records
receive the 1?
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.
probably not needed if the fields you need from the info/default
table are in global fields
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
same here, except FMPA 8.5v1
One other bit of info, we can now eliminate the GetRepetition
function, by typing
Field[2], Field[3], etc.
The [2], [3], indicates the repetition.
This can be used in merge format as well, as in <<Field[2]>>.
;-)
M.
-----------------------------------------------------------
Judith Foldi
Things never were the way they used to be
[Mac OSX 10.4.8 Intel Dual Core FMPA 8.5v1]
--
Michele Olson
FileMaker 7 Certified Developer
AppleSauce Productions, Inc.
Tel 218.327.2671
