This certainly works. Down side is that I do have to hard-code campaigns, and sort field as second field has to be displayed to sort.
All-in-all, acceptable! Thanks. Ron From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Richard S. Russell Sent: Friday, January 02, 2009 9:55 AM To: [email protected] Subject: Re: Sort Value List / Portal scroll bar On 2009 Jan 2, at 8:32, Ron wrote: Many thanks for your reply. I forgot to mention that my Value list field is a Year plus a fund-raising campaign, thus I can't define it as numeric, thus a negative has no effect. Maybe, maybe not. Let's say you have 3 fund-raising campaigns: Annual Campaign Year-End Campaign Guest Artist Campaign You can calculate a negative numeric version of the year/campaign combination like this: NegYearCamp = -1 * ( Year + Case ( Campaign = "Annual", 0.1; Campaign = "Year-End", 0.2; Campaign = "Guest Artist", 0.3; 0 ) )
