Hopefully, I can explain this without confusing everyone.
I have a database that allows users to go in and keep track of the hours they spend on certain projects. They enter this information via a Time Log Form which contains a subform - Time Log Hours. In the subform, the users fill in 5 fields - 3 fields determine which project they worked on, 1 field is for the hours they worked and the last is a comments field.
What I want to do is have these hours feed into another form, a Project Form, so we can keep track of all the hours that every employee works on that specific project. The catch is, that the three fields that determine which project they work on, must match the same three fields on the Project Form. So, the possible combinations are endless.
For example: if Jane works on project A T K - [A (field one) T (field two) K (field three)], then those hours must automatically fill into an HoursWorked field in the Project Form whose three fields match up to A T K.
Is this possible and if so, how complex is it?
Any help would be greatly appreciated. Thanks in advance.
I have a database that allows users to go in and keep track of the hours they spend on certain projects. They enter this information via a Time Log Form which contains a subform - Time Log Hours. In the subform, the users fill in 5 fields - 3 fields determine which project they worked on, 1 field is for the hours they worked and the last is a comments field.
What I want to do is have these hours feed into another form, a Project Form, so we can keep track of all the hours that every employee works on that specific project. The catch is, that the three fields that determine which project they work on, must match the same three fields on the Project Form. So, the possible combinations are endless.
For example: if Jane works on project A T K - [A (field one) T (field two) K (field three)], then those hours must automatically fill into an HoursWorked field in the Project Form whose three fields match up to A T K.
Is this possible and if so, how complex is it?
Any help would be greatly appreciated. Thanks in advance.
