AnsweredAssumed Answered

Alphabetical sorting

Question asked by Pedorthist on Apr 28, 2010
Latest reply on Apr 28, 2010 by philmodjunk


Alphabetical sorting


I am new to databases and Filemaker in particular.  Have been learning about all features.


I have a functioning database with 4200 patient records created and it is working well.  Here is my question.


When one of my employees enters a new record the records are, of course, kept in the order in which they were entered.  When a search is performed not all records for a lastname are located.


It seems to be resolved if I do a manual alpha sort of the db by lastname.


I know there must be a way to write a script to automatically do an alpha sort after each new record is entered.  I just don't know how to write this script so that it can be automatically executed, invisible to the user.