- Joined
- Apr 13, 2012
- Messages
- 8
- Reaction score
- 0
Hello-
I have a data entry form that is created off of a linked table. The field in the table I need to prevent duplicates of is called EmployeeID. When the user fills in the EmployeeID in the form, I would like to be able to prevent them from submitting it if the record already exists.
I know that you can change an index in a table to prevent this but since it is linked I am unable to change the design...
Any help is appreciated! Thanks!
Ashley
I have a data entry form that is created off of a linked table. The field in the table I need to prevent duplicates of is called EmployeeID. When the user fills in the EmployeeID in the form, I would like to be able to prevent them from submitting it if the record already exists.
I know that you can change an index in a table to prevent this but since it is linked I am unable to change the design...
Any help is appreciated! Thanks!
Ashley