Hi every body. i made a bounded data entry form that is based on a form and a sub form. But when i try to run it i get many errors. I be happy if some one help me how i link these two tables since draging the sub form to the form did not establish the reletion automatically! I be happy if some one teach me how to link form and sub form together. Below u can see the two query which is for the main form and sub form.thanks


http://i5.photobucket.com/albums/y18...constraint.jpg =====> table reletionships pic

QTimeKeepingemployeno,name ==>query

Code:
SELECT dbo_Employee.employeeno, [dbo_Employee]![lastname] AS EmpName
FROM dbo_Employee;
subform query:

Code:
SELECT dbo_Hours_worked.*, dbo_Task.description
FROM dbo_Hours_worked INNER JOIN dbo_Task ON dbo_Hours_worked.Task = dbo_Task.taskcode;