am dealing with 2 tbls 1-m;
tblEmpl(empID(pk), Fname,Lname, phon#) &
tblTimeReport(TimeReport(pk), empID, Date, startTime, EndTime)
how can i avoid 2 duplicate on tblTimeReport; i mean an employee can come & work the same day at differnt time, but i can enter same day, same times which is duplicate?
am using acess so i cant use trigger, but how can i mk empid, date, stTime & end time unique?
i added PK to all this col..didnt work.
under tbl design on index.. i had yes, no duplicate...but still it allows duplicate value..