Larry definitely has lots of experience! Dennis
________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, October 09, 2009 4:48 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: IFEQ Larry, You speak as the voice of one who has experience. Thanks for the suggestion. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Friday, October 09, 2009 4:43 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: IFEQ << The company now wants the change for another item 'PR'. >> Save yourself some time and abandon the IFEQ technique now. They'll only want another term next week, and another one after that. Instead, add a TermTranslations table and put in records for PM and PR. Then change your report as follows: rTermTrans = Translation IN TermTranslations WHERE Term = .SORTONE rPrintTerm = (IFNULL(.rTermTrans, ShipName, .rTermTrans)) Then, when they come back for more changes, just add the new translations into the table. -- Larry
