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
