For setting a sort order that is other than alphabetical, we use a simple field that has a number in it for the sort, that way we can change the sort order anytime we like.
Not sure if that helps much or not, just thought I would throw it in. Will Cooksey University of Arkansas -----Original Message----- From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Tim Mansour Sent: Thursday, May 28, 2009 5:48 PM To: [email protected] Subject: Re: Value List Display 2009/5/27 Richard S. Russell <[email protected]>: > What I'd REALLY like is the ability to SHOW only 1 field and SORT on a > different (hidden) one. I originally encountered the desire to do this when > I came up with a list of street-type abbreviations and wanted to show only > the abbreviation but have the dozen most common ones (St., Rd., Dr., Ave., > etc.) appear at the top of the list and have their spelled-out versions next > to them. We can already specify that a value list is based on a relationship. It'd be nice if FMI enhanced this by honouring the sort order specified in the relationship rather than always displaying the value list in alphabetical order; this would be a simple solution to your problem. I've just lodged a feature request to that effect. -- Tim Mansour <[email protected]> Neologica Print & Promotions (ABN 63 904 335 408) 159 Commonwealth Street : Surry Hills NSW 2010 : Australia Mobile 0405 500 846 : Sydney 02 9043 3223 : Melbourne 03 9012 7441
