How to link form and subform

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;

---

You can use the field linker form to link them.

Quote:

---

Originally Posted by RobDog888

You can use the field linker form to link them.

---

Many Many thaks for your nice picture. Well now i know where to go. But could u tell me what criteria should i use in order to put those field names in the field linker .I be happy if u explain me a little more.thanks

One of the tables - dbo_Task and dbo_Hours_worked should have an employee id field or something that relates to the
dbo_Employee table. These two fields are what you should link on. ;)