Cascade Update in AX

Many people think that cascade update functionality is not available in AX. Since delete actions of ‘Cascade’ type are available to provide cascade delete functionality then why there is no cascade update. As usual Microsoft will not leave you in the middle of the sea. Cascade update is the default behavior of Ax if you create relationships between two tables via an EDT. Consider the following example.

A foreign key (one-to-many) relationship exists between AssetGroup and AssetTale. Field AssetGroupId in both tables are extended from AssetGroupId EDT. The relations node of AssetGroupId contians a relation b/w the two tables. Now if you update AssetGroupId in the AssetGroup Table, it will automatically update the related field in the AssetTable.

One thought on “Cascade Update in AX

Add yours

  1. Hi sir, this information is very help, thanks. But I cannot replicate it. First i change the GroupId field to be editable at AssetGroup table, modify one of the Groupid. It didnt change the assetGroup id at the assetTable. I monitor them at the table browsers.Can you please give some more instruction? Thank you.Benlora

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: