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.