Create multiple records from a single form

[gracegrenier]

Hello All,
I have had a request from mgmt and I don't even know if it is possible. We have the following objects in our database
Table-Non Production ([Work Date], [Department], [Task], [Quantity])
Table-Tasks ([Task], [Prod or non])
Form-Non Production Entry Form ([Work Date], [Department] combo box, [Task] combo box, [Quantity])

Now, there are 257 non-production tasks so the combo box on the form is too long. Mgmt would like to have a single form that just had the entire non-prod task list with a quantity field next to each task so they could just enter in the date and department one time, then run down through the list and enter the total quantity per day for each task. That would save them a lot of time, but I can't figure out how to make the form split into a different record for each task, taking the date and department from the main form. The only option I see is to make a new non-prod table where there is a column for each task, but that would make the table around 300 columns wide. Is there a way to do this that I am not seeing?

Thanks,
gg