Duplicates in Subforms

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I hope I'm able to explain this. I have a form with a subform. The form
lists an employee name and subform lists all the training the employee has
had. In the subform I have a combo box that lists the all workstations
available. Each employee is trained on a workstation. I would like to
prevent a user from entering duplicate workstation information on an
employee. Is there a way to check if the workstation has been entered for an
employee if a duplicate entry is made? Thanks.
 
In the table that has employee identification and workstation information
create a compund index and set to unique, Ignore Nulls - Yes.
 
Back
Top