Something like 'On Delete Cascade'

[wkd24154]

Hello,

I need to know if there is something like 'on delete cascade' for master-detail relations. Actual I delete at first all detail records before I delete the master record. Is there any better solution?

 

[Marco Kalter]

Can't you use a foreign key (or trigger) to implement this delete rule on the server? Otherwise you would need to implement an AfterDelete event for the master dataset.

------------------
Marco Kalter
Allround Automations

 

[wkd24154]

I can't use a foreign key (or trigger) on the server. So I have to delete the detail records in the BeforeDelete trigger in the master block. Thank you for the response.