OnInsertRecord

sabzamsabzam Member Posts: 1,149
Dear All,

I need to retain the user from inserting any new records in a table if a certain condition is satisfied. In which trigger should this be done and what is the exact code to stop the insertion from taking place?

Answers

  • WaldoWaldo Member Posts: 3,412
    OnInsert trigger of the table... :-k . If you place an ERROR, the transaction will roll back.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • sabzamsabzam Member Posts: 1,149
    Hi,

    it has worked perfectly thanks for your help. By the way just to let you know it can work on either form or the table the only difference is that when the coding is done on the table the form won't realise that the insertion has not been done if there happens to be any coding on the on insert trigger
Sign In or Register to comment.