Hi,
The solution lies in SQL, not in c#.
You can add a foreign key to your field this way :
ALTER TABLE [tblAttendance]
ADD CONSTRAINT [FK_tblAttendance_tblEmployee]
FOREIGN KEY [Employeeid]
REFERENCES [tblEmplyee] ([Employeeid])
ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
It is advised to also put an index on your foreign key :
CREATE INDEX [IX_FK_tblAttendance_tblEmployee]
ON [tblAttendance] ([Employeeid]);
GO