I would guess that it is one of two things; either the said data has been deleted accidentally or on purpose, alternatively the relationship to the data has been broken an example of this would be if a driver exists & so does relavent data in other files & the key that linke the two has been changed, probably the Driver ID code.
Has anyone been doing any work on the system recently?
Has any Id been changed?
When did this appear to happen? recently?
DO you have older backups?
The reply by Blackcat is excellent. (Thank you!). I will add that you can recover the file. If FileMaker is launched, close the file. Pull down the File menu and select "Recover" and recover the file in question. The information from the file is read and placed in a new RECOVERED file. When finished, open the RECOVERED file. It is not a cure-all, but it is a way to repair a file.
Can I chip in a word of caution to the 'Recover' step? From memory, in FM5 you will find (sometimes) that as part of the recovery process it will create 'new' fields and insert them into the field list. The database will be fully 'recovered', and the post-recovery dialogue will confirm that, but if you check 'Define Fields' you may find additional fields called 'Recovered1, Recovered2, Recovered3..' etc. They will be there in addtion to the original fields.
There are two problems with that:
- it makes the field list look amateurish (minor)
- it totally messes up, without warning, any scripted import or export routines, for example (major)
The belt-and-braces advice is usually to recover the data-file as described, then get a known good clone from your back-up of the original file structure and import all of the recovered data into that clone.
I recognise with your week-old back-up this is probably not possible for you, but it may help you (or someone else) avoid an import / export (and when I think about it, a LookUp?) problem too, down the line a bit.
Maybe TSGal can confirm if that behaviour was killed after FM3?
Your observations are correct.
If there is damage to the structure, and FileMaker recognizes there are fields there but cannot determine the name of the field(s), then "Recovered 1".... "Recovered n" is used.
As I said. This is not a cure-all. However, assuming data is disappearing and not mistakenly deleted, more data could disappear if the situation isn't addressed.
Most likely, the file is not damaged, but if I didn't mention this option, I would be neglectful in my duties by not presenting as many possible solutions.
Of course, of course! The 'Recover' command has saved my bacon on innumerable occasions! I was only trying to get to the Pass and head off the chance...
Thanks for your input everyone! I've tried the Recover command, but the data is still missing when using the recovered database. When recovering a database, how far back does it go to recover data?
Any other thoughts?
I'm not sure what you mean by "how far back does it go to recover data". The Recover command will take the current file and clean up any possible corruption to the file. It will reset the indices, layouts, data, etc. It appears the data is lost from the current file, so you may want to look for an older backup to retrieve the data.