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
