Is there one computer that is running Filemaker all the time? The server? Is that where the database is kept?
When you open Filemaker do you have the database on your computer, or do you choose Open Remote under the File Menu?
Windows or Mac? All Filemaker version 12?
Hi Thanks for your help.
We have one computer running Filemaker Server 12, and 5 other computer running filemaker pro 12. (We were running 9 on all machines and server 11 on the main server.)
We have a face plate that should be looking at the server to find info and make changes.
If I want to change how things work, that is when I need to open remote.
We are on max OS X
I don't even know if the conversion has happened correctly. On filemaker Server 11 when I looked up the databases there were ticks to say everything is correct. This just has grey dots.
Two possible explanations come to mind and I'm guessing that DavidAnders is thinking along similar lines by his questions:
You may have more than one copy of the database file and thus the data can be found only when a particular copy of the file is searched. If your "faceplate" is a FIleMaker File on the local machine that is intended to link to a file on the server with external data source links, I'd check that file's references on the different computers to make sure all refer to the same exact copy of the file.
You may have a damaged index on one or more fields. A damaged index can produce erratic results such as you describe here.
To rebuild the index of a single field:
- Open Manage | Database | Fields and double click the field
- Use either the storage tab or the storage options button to turn off indexing.
- Exit Manage | Database, then return and turn indexing back on.
You can also rebuild all your file's indexes by importing all the data into an empty copy (clone) of your file.
If you have FileMaker 11 or newer, you can use Advanced Recovery options to rebuild your file's indexes:
- With the file closed, select Recover from the File Menu.
- Select "Use advanced Options"
- Select only: "Copy File Blocks as-is" and "Rebuild Field Indexes Now".