Hello everybody,

When you open a database in FMP, weather it is local, through FPM network sharing or through Instant Web Publishing, the records are sorted in the order they were entered. You can always sort the records using the sort option in Records menu. But the users that will do the data entry and the users that will be consulting the data in this database are... well... somewhat technologically challenged... And the manual sorting of the database seems to be a little complicated for them. I have to admit, being lazy myself, I find this task to be tedious at best.

Now, I've been "playing" with FMP for a couple of weeks now. It's relatively simple to use and chock full of fun features! Yay! There just has to be a way to automatically sort the database when opened/modified.

Any pointers?

Thanks!

You can create a script that utilises the 'sort records' script step and then nominate this script to be run on opening the file (File menu > file options> open/close tab).

This script step has a 'no dialogue' option to stop the user changing the sort order if needed.

HTH

Phil

Thanks, I'll check it out and keep you posted.

Yay! It works! Thank you for the help.