I am trying to create a timesheet entry tool for a consulting business and need to create an input form for the capture of daily entries by consultants. Attached is the data structure, but in summary the following tables should be the sources for combo boxes: 10_Customers; 12_Projects; 13_Workorders; 21_Consultants; 31_TimeSheetDays
The form should allow the user to select the consultant name from 21_Consultants then the Customer from 10_Customers, the Project from 12_Projects (only those linked to the selected Customer), the work-order from 13_Workorders (only those linked to the selected Project), and finally the week ending date. They would then have a grid to select the day of the week from 31_TimeSheetDays and then enter start/finish times along with comments on the work completed - there could be multiple entries per day in the grid.
On completion they would select an update button that would save the selected values from the input tables along with the time/day details to a a table called 32_TimesheetDetail. Other linked tables with fee structures could then be used to generate invoices. Spec-for-changes-to-Timesheet-to.xlsx