i am trying to prevent delete parent record which has child records , i used the restricted delete actions but it dose not work as expected ????
did any one face these problem
*This post is locked for comments
Yes, in regards to tables that are part of a table inheritance. The problem occurs in all cases where
- a table references a table that is part in a table inheritance
- the referenced table has a restricted delete action for the referencing table
If you try to delete a record in the referenced table, the restricted delete action should prevent the deletion. But although the warning "<table> cannot be deleted while dependent <table> exist. Delete dependent <table> and try again." is displayed, the record is deleted.
You can reproduce the problem in a standard AX 2012 R2 system when you try to delete a product master that is referenced by a product model version.
My guess is that although the restricted delete action of the product master gets executed during delete validation, the result is overwritten in the delete validation of the EcoResProduct table it inherits from.
thanks for your reply FI-INWAY,
i found that the RelatedTableCardinality property is not set correct in the child table i should put it to ExactlyOne
it is resolved now
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 4
Guy Terry 2 Moderator
Nayyar Siddiqi 2
