Search for duplicate entires

  • Thread starter Thread starter Mark H
  • Start date Start date
M

Mark H

Hi,
I am trying to get users to input a time sheet on a daily
basis.

Can I pop up an error if the table contains 2 common
items already?
How do I use validate to check on 2 fields?

eg: This user has already entered time for today.
 
Mark, Assuming you have a UserID or similar field, you can add a CreatedDate
field with default value =Date(). Create a unique index called something
like IX_UserDate on the table and include both columns. / Mattias Jonsson
 
Back
Top