Re: How can delete a record in a master-detail relation

From: nick048 <nicosia.gaetano_at_moonsoft.it>
Date: Sat, 16 Feb 2008 08:20:45 -0800 (PST)
Message-ID: <1843c9f0-29d6-4267-a6cf-1f6bba88cb1d_at_p73g2000hsd.googlegroups.com>


On 16 Feb, 09:29, nick048 <nicosia.gaet..._at_moonsoft.it> wrote:
> Hi to All,
>
> I have created a Form with 3 Blocks:
> 1) MASTERBLOCK, Table1, PK MASTER_CODE
> 2) DETAILBLOCK, Table2, KEY = DETAIL_CODE
> 3) TOOLBAR with button SAVE, ADD, DELETE etc...
>
> All Work fine! I can Add, Modify, Save all in the Master and in Detail
> Block.
>
I have solved. In relations I have set to cascading the property. Bye
Gaetano

> But If I try to Delete a Master Record, this message is displayed:
>
> CANNOT DELETE THE MASTER RECORD IF THERE ARE CORRESPONDING DETAIL
> RECORDS (NB. I have translated the message from italian language)
>
> In the trigger WHEN-BUTTON-PRESSED of DELETE Button I have entered:
>
> Delete_Record ;
>
> Please can anyone help me in order to delete the master and the detail
> records?
>
> Thank You and Best Regards
> Gaetano
Received on Sat Feb 16 2008 - 17:20:45 CET

Original text of this message