I just had the luck of being appointed responsible for all our scanners and need to create a database where these can be tracked.
I am now trying to create a form where the hardware data is to be entered but to avoid conflicts i need to validate the serialnumber entered against what is already in the database.
After having tried for days to make it work I now turn here for help:
How do I validate what has been entered in a field called "SerialNo" (regular textfield as serialnumbers can be both numeric or text or a combo) against what is already present in the database.
I have a view showing all scanners where the serialnumber is column 3 (Country is first and office is second, Country is sorted and categorized, office is sorted). The SerialNo column is also sorted.
What I need is to check the above view for the serialnumber the user entered and if it does not already exist let the user continue to enter data, if it does then the user should get the existing document instead.
Does anyone know how to fix this?