>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.
Hola Luis,
AFAIK, having a unique key for each record in your child table is needed, for identifying wich record will be updated. So u will have to use a composed key, with the foreing key + another field that uniquely identify each child's record.
HTH,
J. LUis
J. Luis Santiago Rodríguez.• CADIS • E-mail: jlsantiago@iserve.net.mx• Ciudad de México.