>>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
Gracias J. Luis,
I dit it and it worked !.
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould