Determine if a field entry matches value list records
I'd like to be able to check if a user has entered one of the acceptable values from a value list in a field while still allowing them to override the value list.
The setup: a field (Source), a value list from a field in a related table in another file (Source ID)
I want a script that is triggered by the user leaving the Source field. It will check the data entered in Source against all of the values in Source ID. If there is no match, the script will show a Custom Dialog to ask the user to reenter the information or to add the source to our database. I don't want to automatically update Source ID because there will be times that the user will want to have a Source that should not be included in the Source ID database.