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 ?
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
Welcome [:)]