sundaram
Registered User.
- Local time
- Today, 05:01
- Joined
- May 28, 2009
- Messages
- 36
I have 2 tables:
1 tblEmp, 2tblTime
tblEmp consist of empid empname where empid is primary key
tblTime consist of empid, empdte, empHours
Here When I am entering data tblTime it should be in on particular date empid and empdate should be allowed and it should not be dublicate date of the particular empid.
I have tried empdte as primary key in the tblTime. But it is not working properly. Please advise. I appreciate your kind reply. I hope i have cleared my query.
1 tblEmp, 2tblTime
tblEmp consist of empid empname where empid is primary key
tblTime consist of empid, empdte, empHours
Here When I am entering data tblTime it should be in on particular date empid and empdate should be allowed and it should not be dublicate date of the particular empid.
I have tried empdte as primary key in the tblTime. But it is not working properly. Please advise. I appreciate your kind reply. I hope i have cleared my query.