Yes i use this formula for check ID , password perUser and anything to pull data like this OR ( [User Level] <= 10 , [แผนก] = “HR” , AND( [User Level] <= 10 , LOOKUP([Member ID] , “HR.Members” , “รหัสพนักงาน” , “แผนก”) = LOOKUP([ผู้ลา] , “HR.Members”...

just try LOOKUP formula i thinks it easier to use LOOKUP([ Column in this row for ref ] , “Tablename” , “Column in Tablename for REF” , “Column to Pull value”)

i got this problem too , dont have liner and wrong value when scanned.