Not having any success filtering a lookup column when using the "When a row is added, modified or deleted" trigger and unable to find any resources on how to do it. Any help is much appreciated.
Basically all I want to do is to make sure the trigger does not fire unless the lookup column being selected is of a certain value. Example:
A main table called Travel, and Country is one of the lookup columns. If user selects, for example Australia, then the trigger activates. If user selects other countries, nothing happens.
