M
Moumst
Hi to all,
My form is based on a web service connection returning a typed dataset.
The dataset contains one to many relationships with update and cascade
delete foreign key constraints rules (both on dataset designer and on the
database itself).
I use master/detail control to display both master (one) and detail (many)
information. The problem is that when I try to delete a row in the master
table, the infopath client return the following error message:
"InfoPath cannot modify or delete this value, because it is a key that is
being used by other parts of the form. To modify or delete this value you
must first remove all other references to it. The following column refers to
this value"
This error is thrown between the onchanging and onvalidating events so I
really cannot act upon this (except deleting child rows in the "changing"
event but i don't like this in case of validation errors.....)
I tried to create a test form with master detail control based on a simple
main datasource I manually created and when i delete a master row infopath
perfectly delete corresponding detail rows. So I think the problem is on the
dataset stuff managed by InfoPath. It seems not recognizing the cascade rules
on delete.
Does anybody have tried or have a solution for this?
Many thanks
My form is based on a web service connection returning a typed dataset.
The dataset contains one to many relationships with update and cascade
delete foreign key constraints rules (both on dataset designer and on the
database itself).
I use master/detail control to display both master (one) and detail (many)
information. The problem is that when I try to delete a row in the master
table, the infopath client return the following error message:
"InfoPath cannot modify or delete this value, because it is a key that is
being used by other parts of the form. To modify or delete this value you
must first remove all other references to it. The following column refers to
this value"
This error is thrown between the onchanging and onvalidating events so I
really cannot act upon this (except deleting child rows in the "changing"
event but i don't like this in case of validation errors.....)
I tried to create a test form with master detail control based on a simple
main datasource I manually created and when i delete a master row infopath
perfectly delete corresponding detail rows. So I think the problem is on the
dataset stuff managed by InfoPath. It seems not recognizing the cascade rules
on delete.
Does anybody have tried or have a solution for this?
Many thanks