BTW, please do not use UPPER case letters on every first letter of the word. Your message is hard to read. It's in the rules and regulations actually.

>>I Have A Stock Master File. When I Run A Form For Sale For A Particular Stock I Don't Want To Allow The User To Append A record in that Sale Transaction Table. I Have Used The Insert Trigger On Sales Table Which Checks Whether There Are Records Existing in the Stock Master. If There Are No records It Does Not Allow To Append The Record Through A Statement called "Return .F." In The Trigger.This Command Displays A VFP Message "Trigger Failed". How Do I Avoid This Message.Can I Use TableUpdate Or Tablerevert Or Rollback Commands And If Yes How?? My Tables Have Buffer Mode Override Property Set To 5.
>>
>>can AnyBody Help Me??
>
>Triggers will not be avoided firing once the actual event is being done i.e. INSERT, UPDATE, DELETE. DELETE the trigger if you want to avoid it firing.
>
>Better handle the checking of existing of records in a separate procedure or custom method property if you are not yet accustomed with TRIGGERS.