I have a table for “Drivers” It contains DriverID and is a key Only an admin can add drivers to this table.
A second table is for “Van Checks” it also has a DriverID Column (not set as a key - but could be if I need to!)
I want to allow drivers to enter the driver id in the van check part of the app but not allow them to proceed if they are not found in the Drivers table.
How would I do this please? And perhaps display a warning if they are not valid!