A
Access Beginner
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?
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?