FileMaker files are always in record creation order. You can sort them
and they will appear in your sorted order, but nothing changes on disk and the
sort order is not remembered from session to sesssion. To have them always
appear sorted you can create a script that runs at open time that sorts the file
(may be expensive if it is a large file). Or you can export the file in sorted
order, then delete the file and recreate it from the exported information.
However This is fraught with difficulties if the file has relationships with
other files.
-----------------------Original Message-----Otis, I am fascinated by your response below. I also would prefer to sort by the actual code rather than the code description. I tried to do what you did, went under define value lists, selected source code/description, specify and chose the first field. But when I went back and looked at my source codes, they are still in the very same order. I tried quitting filemaker and reopening it, but still nothing...any idea as to what am I missing?
From: Amy Sundberg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 1:14 PM
To: TechRocks Support
Subject: [support] source code sorting
Thanks,
Amy
--
Amy Sundberg
Associate Director
Books For Africa
www.booksforafrica.org
Subject: Re: How do I order the source code drop-down list?
From: Michael 'Otis' Lavitschke <[EMAIL PROTECTED]>
Date: Fri, 25 May 2001 13:18:53 -0500
X-Message-Number: 7
The Source Code value lists are calculated and the only way I found that I could put some order to them was to open the source code/descrip value list, click on the
corresponding Specify button and then decided how you want the list sorted by choosing either radio button on the bottom of the dialog box.
Sorting by the first field results in an alphabetical (numerals first) list of your source codes with their descriptions.
Sorting by the second field results in a list that is sorted by your descriptions of your source codes alphabetical list (numerals first).
I prefer the first sort...
-otis ------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
