>>>Two weeks ago, I was working on a form having an updatable view. At that time, I was still designing the form. While testing the form, suddenly, I had an error. After the error, I found that the value I entered in an updatable field in that view had been reflected to the entire table. Which mean, all the records in the table suddenly had a value of 30 for that field.
>>>
>>>Now, that is something. Anyone has already seen something like that?
>>
>>Michel,
>>
>>I have seen this before. I don't remember exactly what caused it, but I know it had something to do with the field I had checked as the key field in the view definition.
>
>That occurs when multiple records have the same value in the field(s) that you've defined as your key field(s) in the view. In your case, I'll bet that your key field was empty for all records.
Thanks, now I remember. Yes, that was it. It also occured after an error which caused a crash. So, ok, maybe it was normal. :)