>Hi, all
>
>I have a view with a composite key, when i do tableupdate to update de database visual fox tell me,
>
>WARNING: The key field defined by the key field property for 'myTable' is not unique.
>
>I defined that key field is not unique, what's the way for VFP don't show this warning.
>
>
>Thank's in Advance
>
>Joao Batista
Joao, if your key field is not unique tehn VFP cannot properly identify the record to update.
The purpose of the key field is to be unique. If you need that field which you are using as a key now for other purposes
you should add another key field which is truly unique and used only to identify the records (it is called the surrogate key)
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison