I recovered the file (File > Recover...) and all is well. Why didn't I think of that already? Doh!
I'll leave this thread here in case it helps other users, though the Mod is free to delete it.
Just a quick caution that a recovered file is not meant for production use, but rather as a source to recover data from.
I suggest you look for an earlier saved version that does not have this problem and import current data into that file if possible.
Recovered files may have additional issues that are not immediately apparent and may cause complications further down the road, such as missing fields, layout elements and so on. The recover command focuses on recovering the data, sacrificing logic and interface if needed.
Alternatives to try if you don't have access to a good backup:
You can try to save the file as a compacted copy.
If you have Filemaker Advanced, you may want to try using the File maintenance functions under the Tools menu.
Thank you, Andreas. I do have FMP Advanced v9 and will check into that. I used the recovered db all day yesterday, testing its functionality and adding client-requested features. It seems to be complete (knock on wood).
this is documented in the Knowledge Base
FM9 Recover now "fixes" this
so, this is one special case where using a Recovered file is actually ok
I have collected other info (and warnings) here
Thanks for this info. It is the first time I've seen Filemaker endorse the Recover function for a production file.
I still wonder if any of the less invasive methods solves this issue, though.
Your info page was very interesting and I will peruse it as soon as I have the opportunity.
A great resource. Thank you, Greg.