Last post Mar 29, 2006 09:01 PM by geoffHome
Mar 29, 2006 09:01 PM|geoffHome|LINK
I'm using the Detailsview and AccessDataSource. I'm wishing to use the
Cascade Update Related Fields option but having difficulty understanding what I must do to implement it.
For example if I have an ORDERS and a CONSULTANT table and delete a Consultant I want a Null entry in ConsultantID field of ORDERS.
In building this page I've used the following approach:
SelectCommand="SELECT ConsultantID, Name, [Position], Profile, email FROM Consultants WHERE (ConsultantID = ?)"
Also I'm using
However because I've enforced 'Cascade Update Related Fields' I get an error message when trying to delete a Consultant about not being able to delete record because it is involved in other tables. This message gets activated before
I can carry out any processes involved in my 'ConsultantDetail_ItemDeleted' module.
What am I doing wrong? Sorry about the long question!