Hello Dennis,
>You said that the better way is to have Delete trigger for Idetail table.
>How can i do this ?
You should have a Primary key index in your invoice table and related Foreign
key index in your Idetail table. Then, in your DBC designer establish permanent
relation between tables (drag-n-drop primary key index over foreign key index).
And, finally, right click over this permanent relation (thick line between
tables) and you choose Referential integrity item. You'll get the form where you
have the choice between Insert/Delete/Update triggers for each couple of related
tables. In DELETE option choose Delete. After this done, you'll have a delete
trigger that will delete all related records from Idetail table whenever you'll
delete a record from Invoice table.
>Hope you can teach me ?
Hope this help, if something is unclear, feel free to ask again
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer