You may have some FileMaker External Data references which use the network-file format in your system. Those will search the FM network for any available file of that name rather than just the file in the same directory. Try cleaning up any data references where the Net or Network format of the file reference is used to stop the network-searching.
Thank you Stephen.
But, as I said, a one file solution – so no external references to network files.
I'd still check the external references...
... and save a compressed copy...
... and run a DDR to see if there are any paths...
What's in the 12.0v4 update?
The thing is... did you have data for one host in it then clone/copy the file for the next host? I suspect so if it is clinging on to historical paths.
Just doing that, Lindsay, using a fresh DDR in BaseElements.
And yeah, what's in the 12.04 Update? After the desaster with server update to 12.04 I'm still waiting. And FM Inc. does not say very much about changes.
And yes, the Versions on different machines are all copies (clones) of the same file originally.
I'll keep you informed.
--edit a minute later--
there is only one correct relative file reference in the whole thing pointing to the "Documents" file (a FMP12 file) on the same host.
In none of the cases this file or reference to it was involved.
...and here are some interesting findings...
Recap: The file "MyFileName" is open in a local client, hosted from ServerOne. Another instance of a file with the same Name "MyFileName" is hosted on ServerTwo. Also this is open in the same client.
Both files contain the table "MyTable" with datafields from that table(occurence) in a layout named "MyLayout". But the contents of "MyTable" is different in the two versions and some fields exist in one but not the other files' table.
Now do the following. Goto the layout "MyLayout in a window that belongs to file that you opened last. Then open the data viewer and retrieve the fieldnames on that layout with
Getfieldnames ( Get (FileName); Get (LayoutName))
This returns a list with so many entries as there are fields on the layout. Some of the entries are blank! An entry is blank for all the entries that exist in the last opened file but are not contained in the first opened file.
Now close the first file, and reevaluate in Data Viewer: voìla - all fieldnames come up.
Reopen the first file, ot the corresponding layout in the first file and look what happens in Dataviewer: a mixture of the two results appears; all fieldnames always appear in the same order, now in the last case with gaps in new places.
Again we guess what happens. FM gets the fieldIDs of the elements on the layout in the place where we want it to look. FM builds a list of these IDs. It then retrieves the corresponding names for the ID, leaving an empty space where no name is found - because it appearantly looks in the table definition of the wrong file!!
We start now testing with the current release of FM 12.0v4 to see if this was a problem acknowledged and silently solved or if it still persists.
In the later case we would prepare a test file set and make a bug report.
--- tested in 12.0v4 --
The same reproducable (mis-)behaviour!