I love it when we can’t agree. 
1st field: Site Name
2nd field: Alarm Type
3rd Field: Site Number
Equation Field for «Site Name»: ‘.LookupSiteNumber’
Procedure ‘.LookupSiteNumber’:
> «Site Number» = lookup(“Station Stats”,“Name”,«Site Name»,“SiteGVR_ID”,"",0)
Field «Alarm Type»
If I enter a name in the «Site Name» field, and press tab, no ‘Site Number’ gets looked up and nothing gets entered into «Site Number» field.
If I enter a name in the «Site Name» field, and press the ‘Enter / Return’ key on a MacBook Pro 2016, the lookup happens and I get a result in «Site Number».
Robert Ameeti