changing order of records created

[carol333]

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

[Lee Smith]

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

[carol333]

many thanks for your suggestions - very helpful

best regards

Carol333