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

nick048 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.
>
> 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

Delete the detail records first.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org