2009/5/27 Richard S. Russell <[email protected]>: > (1) Is there any way I can set up a value list to SHOW values from 1 field > and be SORTED by values from a 2nd (non-displayed) field? > > OR > > (2) What can I use as the contents of a 2nd field that will not be visible > in the drop-down list but will nonetheless enable me to use the 2nd field as > the basis of the higher-level sort?
Not the answer you were probably looking for (and notwithstanding the academic search for a solution) but I wonder if you should rethink your data entry expectations? I'm assuming you have a reasonably length list of possible breeds. Any time I've come across a requirement to enter values from a long list, I (and clients) have been quite happy with using FM9 auto-completion, combined with drop-down lists if required. A moments training on how to use these effectively might circumvent the need for a complex calculated-field solution? -- 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
