Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
No problem.
You have a relationship where 1 Forman has many Time cards. So that is good.
Next you need to have a relationship where 1 Time card has Many employees. They can be then shown in an embedded report in grid edit mode where the foreman can enter the employee names and the time all on that one form.
You can also use the Copy Master detail wizard helper to make a button to copy the Forman's Time Card as it is likely that the Foreman often has a similar crew to a previous day, so that would copy the Foreman, and the crew on that time card in one click.
You have a relationship where 1 Forman has many Time cards. So that is good.
Next you need to have a relationship where 1 Time card has Many employees. They can be then shown in an embedded report in grid edit mode where the foreman can enter the employee names and the time all on that one form.
You can also use the Copy Master detail wizard helper to make a button to copy the Forman's Time Card as it is likely that the Foreman often has a similar crew to a previous day, so that would copy the Foreman, and the crew on that time card in one click.