Search for a string in the database

I have a QR reader on my form. I also have a special table of allowed QR codes, for example there are 20 of them. How can I make sure that when user opens the QR reader and reads some code, the user would be transferred to the screen of success, if the read code is in the table, and would be transferred to the screen of failure, if the code is not in the table?

Can anyone help with advice on how to do this?

There is a text string “X”.
There is a table “Y” with 100 variants of such strings.

I need to open one of two screens depending on whether there is an “X” in the table “Y”

How to do this?

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.