Validation rule that searches for value

  • Thread starter Thread starter amber
  • Start date Start date
A

amber

I want to create a validation rule for a control on a form
that checks the value entered for a match in another
database table. I want to be sure that users are entering
a value that is a primary key (an employee id) in a
separate table.
 
Best approach would be to use a ComboBox that has the other table as it's
control source.
 
I thought about that, however, I have over 3000 employee
ids that would be used.

Would a combo box still be feasible?

Thanks,
Amber
 
It might be a bit slow unless you could find some ways to limit the number
of employee ids a given user might have to look through (perhaps by
department).
 
Back
Top