Relating information from one Combo Box to another Combo box

[Guest]

I am trying to create a timesheet.
Here is what I Have:

Tables: Project, Task, Project-Task Junction, Employee, Timecard

I want our employees to open the timesheet form. In the top of the form I
want the employee to select their name. In the subform I want the employee to
select the project in a combo box. Then in another combo box I want the
employee to select a task and I only want the task relating to the project to
show.

My problem is when the employee goes to the next line in the subform and
picks a new project the previous task changes to the new project. How can I
get the previous task to stay as it was and let the new task list reference
the newly selected project?

 

[i_takeuti]

I am trying to create a timesheet.
Here is what I Have:

Tables: Project, Task, Project-Task Junction, Employee, Timecard

I want our employees to open the timesheet form. In the top of the form I
want the employee to select their name. In the subform I want the employee
to
select the project in a combo box. Then in another combo box I want the
employee to select a task and I only want the task relating to the project
to
show.

My problem is when the employee goes to the next line in the subform and
picks a new project the previous task changes to the new project. How can
I
get the previous task to stay as it was and let the new task list
reference
the newly selected project?