How to link form and subform

[tony007]

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

SELECT dbo_Employee.employeeno, [dbo_Employee]![lastname] AS EmpName
FROM dbo_Employee;

subform query:

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

[RobDog888]

You can use the field linker form to link them.

[tony007]

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

[RobDog888]

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.