We have an existing custom table with a set of values. When the user enters data in the field, it needs to check against the value in the existing table and existing column (same like reference field) and if value is not present, it has to save the new value (same like text field)
