Is this a field of type calcualtion that returns text or is it a text field with an auto-entered calculation?
It is a calculation field that returns text
"zmember" is a global field in the CONTACTS table with "Member" as its calculated value.
Does that make zmember a text field with global storage specified or is it a calculation field with global storage specified in Storage Options?
If it is the latter--a calculation field, I'd go to storage options and remove this option to make it a stored, indexed field to see if it makes any difference. (If this field always holds the same value in all records, it does not need to have global or even unstored specified as a storage option and this might affect how the values update in some circumstances.)
If that does not resolve the issue, can you shed any more light on the "sometimes" in which it does not show the correct value? Any pattern in what you were doing just before the field failed to update. Were you editing data in the contacts or the affiliations table? and on what layout did you have this field where you saw that it failed to update?
"zmember" is a calculation field. I have taken your advice and made it a stored indexed value. So far, I have not noticed any "malfunctions".
If the problem persists I will make note of when/where/how and post again. The time it did not work today was when I first opened the database - the membership types were wrong. Then, after opening and closing the Define database dialog, they were correct.
Thank you very much for your prompt and thorough reply.