Unique ID

[damad]

Hi all,

i have a problem. I need to create Unique records from two fields. Following is the problem. i am trying to make a timesheet data base where we are planning to update daily work timings. The problem is i dont want to have a duplicate Person-date combination. Eg Stephen10-10-2012,James10-10-2012 is fine. If some one is going to enter a same combination twice i have to popup a message. How can i do it? i am struck with this:banghead::banghead:

 

[MStef]

What is the PRIMARY KEY in your table ??

 

[RainLover]

Use AutoNumber as the Primary Key. This makes the record unique.

To prevent duplicates create a "Unique Index" between the Date and Employee fields.

If you don't know how then search Help. Then if you still can't do it post back with the problems you encounter.