How is the storage set for the field?
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.
For standard fields: Options -> Storage tab.
Same info about indexing as above.
What is the relationship Functions?
What are key (match) fields?
Are they the same type?
And of course, the first question should have been: what version FM
and what OS?
M.
On Feb 4, 2007, at 8:33 AM, Judith Foldi wrote:
The Brand field is populated before I import. The original database
was all for 1 brand, so I created the Brand field in the original
DB and populated it with the original brand of x (and yes I
checked, there is no space).
Is there a way to force a calculated field to recalculate? I
couldn't find the answer to that in the Help files or in
"Special Edition Using Filemaker 8".
On Feb 4, 2007, at 8:11 AM, Michele Olson wrote:
Hi Judith,
Welcome back!
First off, the obvious -- when you import is the brand field being
populated?
Is it just populated with an X or Y or perhaps does it have
Xspace, Yspace, etc.?
HTH,
Michele
On Feb 4, 2007, at 7:07 AM, Judith Foldi wrote:
I have a database which I'm converting to handle several brands
of product. I want to have the product logo show up on the screen
to help remind the data entry people which brand they are dealing
with (and because it's pretty) but more importantly, it needs to
be on the invoices when printed.
I defined a calculation field with the result being a container.
Here is an approximation of the calculation (brands have been
changed to protect the innocent):
Case ( Brand = "X" ; GetRepetition ( Functions::Logo ; 2 )
; Brand = "Y" ; GetRepetition ( Functions::Logo ; 3 )
; Brand = "Z" ; GetRepetition ( Functions::Logo ; 4 )
; Brand = "A" ; GetRepetition ( Functions::Logo ; 5 )
; Brand = "B" ; GetRepetition ( Functions::Logo ; 7)
; "" )
When I create new records, the logo's show up but for all the
records i've imported, they don't. I tried changing the field
type and then changing it back, thinking that would force the
recalculation of the field. Doesn't work. I cannot have the
import routine perform Lookups & Calculations on import because I
cannot have the record number fields recalculated. Any suggestions?
Sorry about all the questions, but I've been away from all this
for almost 3 years. I thought I'd retired....
-----------------------------------------------------------
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
-----------------------------------------------------------
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
