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