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:
00019428
Views:
32
>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
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform