>Hello guys,
>I have a one-to-many form, and the grid in my form is
>populated with a view that has fields from 3 differents
>tables, when I update one of the fields in my grid I receive the message "Warning KeyField is not unique
>in table child_table_name", and then it replaces all the children records with the new value, how can I tell Foxpro to update just the child record that I'm updating?. The KeyField can't be unique because this is a 1-to-many relationship, is it possible to do what I want?
>
>Thanks in advance.
Luis: Double check which fields you have checked as 'updatable' in the View Designer. Since you are only updating, not adding new records, you should probably check ONLY the fields you want the user to be able to change.
Barbara