Relating information from one Combo Box to another Combo box

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?
 
I

i_takeuti

Access Beginner said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top