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?
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
Answers
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
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