I recently moved a database from a server to my local mac.  Opening the file when it was hosted on a server, it always opened to the same record.  Now that it is local, it opens to the last modified record.  Not sure why the database on the server acted the way it did, but I would like to have FM open to the same record every time it's opened.  How can I do that?

To me, this is a bit of an odd request. What record do you want the system to "find" upon opening? Can you describe your solution in a bit more detail?

The record I want FM to open to is a record that I use as a template . . . many of my fields have codes.  Having the codes before me right from the beginning allows me to be accurate when entering a new record.  When my database was on the server, it always opened with that record.  Not sure why . . . perhaps it had to do with the fact that it was the first record I created in the database.

The server opens on the layout/record of what was active when the file was last closed locally, before being moved to the server.

The local file will always open where it was closed.

 

Instead of relying on this implicit behavior, what you need is an OnOpen script that explicitly takes you to the layout and record you need.  Check File > File Options > Script Triggers tab

Thank you.