Duplicates in Subforms

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.
 
K

KARL DEWEY

In the table that has employee identification and workstation information
create a compund index and set to unique, Ignore Nulls - Yes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top