Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to make an updatable view in a one-to-many relations
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00019391
Message ID:
00019459
Views:
41
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform