Script Trigger to prompt entry of a new record
I want to create a script trigger for when a user types a Product Code into a field on a form.
The field is linked to a Value List called ProductCode
The script needs to either:
a) Accept an existing Product Code in the Value List, or
b) If the Product Code doesn’t exist, open a New Product Layout to allow the user to enter details for a new product.
Can someone please help.