Morning all, can help my problem with this usersetting,
Username
Validif
AND(
ISNOTBLANK([Username]),
IN([_thisrow_after].[Username],ERP_userlist[Username]),
ISNOTBLANK([Password])
)
Invalid Error
IFS(
NOT(IN([_thisrow_after].[Username],ERP_userlist[Username])),”Username NOT Found”,
isblank([Password]),” “
)
Password
Validif
[Password]=lookup([Username],“ERP_userlist”,“Username”,“Password”)
Invalid Error
“Password is Missmatch with our Record”
Required
IN([_thisrow_after].[Username],ERP_userlist[Username])
Error
ERP_UserList Table
EDIT:
if I use the admin it can pass
