Validation of records before creating
I have 2 tables, 1st Quote 2nd Sales Instruction.
I have a script running by clicking an button on to first DB, to create the Sales Instruction for the current quote when the user wants. which copy the record to another DB ( Sales Instruction DB).
I want to have an script which i want to run before the records is copy. I.E, it will check in Sales Instruction DB wheather the Sales instruction is made for the Same Quote or not( Custome Message with YES OR NO). if its made for the same quote users should be allowed to make another SI for the same. else exit.
Can anyone help me with the script. i took the help of FM Help, but no success.