Hi, Martin: You can do this by opening the non-hosted file with FileMaker Pro, performing a Find All, then Show Omitted to produce an empty found set, and closing the file.
This presumes your OnOpen script and OnClose don't do anything that would alter the found set.
You might even have your OnClose script perform the above operation so you don't need to when you're working on the non-hosted file.
The file must be non-hosted (not as a guest of FM Server or another instance of FM Pro) so the database remembers the found state.
I would suggest one of the following methods ... that are in line with what is already suggested.
- Have a start screen based on a session table. Enter search criterias etc. from there.
- Have a start script ensuring that either nothing or the most relevant - current - records are visible.
If you explain what you want the user to be presented with or what you want the user to be able to do, when starting the solution, we will probably come up with better solutions.
Open and Close the file (via scripting) on a layout for a base table with no records or with only global values in a single record. Be sure that the file closes on that layout when last used unhosted so that layout will remain the default location when opening hosted.
That works. Thanks! I have it set to keep the users off of the data unless they are running a report that just looks at a slice of it.