What version are you on and could you provide a few more details on what you are trying to achieve as well as stating your structure?
Ditto on what Mr. Vodka said.
One general hint: Perform the find, then perform the sort. If you do the same operation repeatedly, script it.
I just updated to Filemaker Pro 10.
I have downloaded the manual so perhaps I can get some information about scripts there.
My objective is to have 4 or 5 ways (search results) of looking at my address book information without having to start from scratch each time.
If you provide a more detailed description of your file, the fields, fields, the relationships. Then we can provide some examples of how to do what you want.
This is not a relational database. It is a group of fields which appears in the database and are related to no other database.
It is the simplest imaginable file which is why it is the same one I set up 25 years ago.
For example, I want to sort them by field (i.e., 2 financial, computer, infrequent). Because they lose their sort in the find, I want to add a sort to the find so that next time I can select the find and simply click on it and find the files sorted as well as selected.
I have been thinbking that this can be done with a script, but do not know. This is where I can use some help and advice.
I am having a hard time following your structure. Could you please list all your field names that you want to find and sort by.
Please keep in mind that we can't see your database. Thus, we have to ask questions to make sure our suggestions will work.
I'm assuming that "2 financial, computer, infrequent" are different values stored in one field of the database. I could be assuming incorrectly.
Here's how to set up a script to find all records with "computer" in your field and then sort the records in the order you desire:
Select Scripts | Manage Scripts...
You now have an edit script dialog open on your screen. Enter "Find Computer" or some such name for your script.
On the left hand side of the dialog, double-click "Perform Find" to make it the first line of your script.
You'll see a button on the lower right corner named Specify... appear. Click it.
Click New... in the specify find requests dialog that has popped up.
Select your field on the left that holds "computer" and Type in "computer" in the right hand pane. Click OK.
Find Sort Records on the left and add it to your script.
Click the check box at the bottom labeld "peform without dialog".
Use the sort fields dialog that pops up to set up your sort order.
Close the Edit Script window, saving when prompted to save your changes.
In the Manage Scripts dialog, you'll see your new script. Make sure that the check box to its left is selected.
Now to find and sort all "computer" records, simply pull down the scripts menu and select it.
I apologize for my tardiness in responding, as I greatly appreciate your help.
I looked at Manage Scripts and think I understand it.
My fields are simple; i.e., one is a name, one is a phone number, one field has different text typed in some records.
Now I need to use the manual to find out how to rename my layouts—after the weekend.