All,
I have an automatic lookup table working great, however, when a value isn't in my lookup table, I was hoping to have a default result of "not found". Any idea how I would tackle that?
thanks!
Go to Settings
-> Lookups
-> Lookup Definitions
Click on your lookup definition, check the Advanced options
checkbox
In the Default matches
text box add not found
, then save.