I have a table which has a list of the work centers for the company numbered 1 - 10
I am putting together a quote database in Access. Part of the quote is to estimate the labor. I was going to have the user enter a record for each of the Workcenters by selecting the workcenter from a dropdown, but instead I would like to force there to be a record in the labor table for each of the work centers automatically so that the user only has to enter the hours and the rate for each.
I have screenshots of the following:
1. The Work Center Table
2. Example of the view that I would like to create
3. View of the query that I am working with.