referential integrity

1
HI   I created a domin model as follows I noticed the following tables were created select * from myfirstmodule$asset select * from myfirstmodule$assettypes select * from myfirstmodule$asset_assettypes   when i delete an asset, i need the myfirstmodule$asset_assettypes to be deleted Similary, i need same logic when i delete asset, myfirstmodule$lookupvalue_asset must be deleted for that asset. Note that the direction of the association is different for both asset_assettypes and lookupvalue_asset   Thank you
asked
3 answers
0

If you double click on the association, at the bottom of the popup you will be able to put : “when I delete asset, delete lookupvalue aswell”

 

answered
0

Hi

 

This is the case already, and the association became red

answered
0

Hello Aliah

 

it should rather be like this

but i got Invalid delete behaviour error

 

Also, when i keep or delete the Asset object, deleting the asset did not delete the myfirstmodule$asset_assettypes, where the option is as below

I am not planning to delete the AssetTypes, rather the association table Asset_AssetTypes

 

we are using Mendix 9.5.0 (build 25874)

 

Thank you

answered