Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to make an updatable view in a one-to-many relations
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00019391
Message ID:
00019428
Vues:
34
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform