DELETE FİELDS

I have a Seminar Table and SeminarTransactions table

If user delete a record in seminar table this record is must be deleted in SeminarTransactions table

How ı can do this ?

What you tried as of now?

Let us know if you tried and got any error…

Let NAV be your guide: did you have a look at the OnDelete triggers of tables like Customer (18), Vendor (23) or Item (27)?

I Write this code ondelete trigger but ı dont know how ı can continue this

Lt.RESET;
Lst.RESET;
IF Lt.GET(Lst.“Seminar No.”) THEN BEGIN
IF Lst.GET(Lt.No) THEN BEGIN
Lst.DELETE(TRUE);
Lt.No:=Lst.“Seminar No.”;
END;
END;

Please try this in test environment only…

try

Lst.RESET;
IF Lst.GET(No) THEN
Lst.DELETE(TRUE);

or Simply

Lst.SETRANGE(“Seminar No.”,No);

Lst.DELETEALL;

Please try this in test environment only…

Lst.SETRANGE(“Seminar No.”,No);

Lst.DELETEALL

It work Thx :slight_smile:

Welcome [:)]