There are several issues you can check.
If global storage has been specified for this field, then you only have one method for all your recipes and the other "methods" have been lost. Only hope is if you have a back up copy where this was not the case. You can check the settings for this field in define fields to see if it is a global field (You'll see "global" listed after it if it is.)
If you have a layout that displays data from more than one table, You "method" field could be from a related table via a relationship that matches to all records in the table where you have defined the method field. If so, you are in good shape and can just fix this layout to refer to the correct table occurrence or fix the relationship.
The databse may indeed be corrupted. Open Filemaker without opening the file and run recover on it to see what is reported and then check the reovered copy to see if this issue was changed.
Things to keep in mind about Recover:
- Recover does not detect all problems
- Recover doesn't always fix all problems correctly
- Best Practice is to never put a recovered copy back into regular use or development. Instead, replace the damaged file with an undamaged back up copy if this is at all possible. You may have to save a clone of the back up copy and import all data from your recovered copy to get a working copy with the most up to date information possible.
Thanks for the quick reply.
In Define Fields .. it shows as Text and Indexed. In Relationships, just a single Table. Ran recover, it asked for the file, so I Recovered it... opened it and it did not help.. Same condition.
It appeared several months ago when I printed one recipe. After the printing. all recipes showed the "Method" from that recipe in all recipes.
I'm just hoping something got set that can then be reset and all methos returned.
My backups may contain a backup beyond the 'corruption' but I'd like to first satisfy any possibility to reset or change something to fix it.
What we don't know is if the value was changed in some way or if the layout is failing to properly display this field from the correct related table. If the value in the field was changed, then your only option is to revert to the back up copy.
How exactly did you print? From a script or by selecting Print from the File menu?
If you used a script, you need to examine that script to see if there is a replace fields step in it that is responsible for this issue. If there is, you need to revert to your back up and also to fix this script.
It'll be a day or so till I can get the backup... hopefully. I'post results them
Phil... many thanks for your help. Ross