I have 2 databases related via a one-to-many relationship.
We have an ongoing problem whereby certain fields (whose input is
controlled by a value list) seemingly randomly change. But they always
change to another value on the value list.
Other fields sometimes change randomly, too. Strangely, a great many
fields NEVER change randomly.
And we NEVER see garbage characters in the changed field (which would
clearly indicate corruption).
I'm pretty sure it's not a rogue script...I modified every script that
modifies any field to write to an "audit trail" field what it's
changing. That turned up nothing.
We're almost certain it's not user error. When the data does change,
it changes from bold colored text (which the primary user of these
databases manually selects) back to black plain text. If a user
selected a different value frmo the value list by accident, it would
remain bold and colored. But that's never been the case...it's always
back to black plain text.
Has anyone ever seen filemaker "corrupted" so perfeclty and
consistently in some fields, but never others, with no garbage
characters, and only with values from the value list?