hi

Is there any way to permanently change the order of records in my database? I know I can sort them by right clicking in a field but I want to change the order that they are in when I open the database - at present they are in creation order, so if I create a record for a journal volume 9 issue 3 then create volume 9 issue 1 afterward, my database will always show issue 3 before 1.

I've been told that's just the way it has to be but would appreciate anyone's advice or confirmation of this

many thanks

Carol

You would need to recreate your records in the correct order, and delete the existing one. You could do this by Duplicating them in the order you want them created. [color:red](work on a duplicate of your file, not the original)

Or:

You could use an Open Script that sorts the records.

Opening Script

Show All Records

Sort [ Sort Order: Field1 (Ascending) ] [ Restore sort order, No dialog ]

Go to Layout [ original layout ]

Preferences

FileMaker >> Preferences >> Document

select the button >> Perform Script

and then Choose your script (Opening Script)

HTH

Lee

many thanks for your suggestions - very helpful

best regards

Carol333