G
Guest
I have a current form that selects a store from a drop down list that fills
the store info. The rest of the form is manually filled out with Project#,
Hours and employees working on the project. It is set up where the employees
are picked out of a drop down list and put into a list box. When saved, each
employee has a line in the table for this project.
Now instead of having just an Hours field they want a Projected Hours when
the project is first entered, and then a Total Hours which to be entered
after the project is completed. I'd like to set up a form where they could
select the Project# from a drop down list and then enter the Total Hours.
My question is how do I get it to update the total hours field of all the
employees that worked on the project? If I create a drop down list from the
Table, it will list the project number 4 times if there were 4 employees
working on this Project.
Is there a simple way to do this or is this going to involve a lot of
coding(which I don't have much experience in)?
the store info. The rest of the form is manually filled out with Project#,
Hours and employees working on the project. It is set up where the employees
are picked out of a drop down list and put into a list box. When saved, each
employee has a line in the table for this project.
Now instead of having just an Hours field they want a Projected Hours when
the project is first entered, and then a Total Hours which to be entered
after the project is completed. I'd like to set up a form where they could
select the Project# from a drop down list and then enter the Total Hours.
My question is how do I get it to update the total hours field of all the
employees that worked on the project? If I create a drop down list from the
Table, it will list the project number 4 times if there were 4 employees
working on this Project.
Is there a simple way to do this or is this going to involve a lot of
coding(which I don't have much experience in)?