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
