I think your application looks like this
Three things to consider:
1) On each Job, every time your Users click Add Request, you will get a form to add a single item to the Job.
2) If you Make the report Materials Requested on the Job table, Grid Editable, your users should be able to fill it out like a spreadsheet but all the material will belong.
3) You can import records to the Job Material Request table. This gets more complicated because to be neat and clean, your spreadsheet has to include the Job # and the Master Material #.
This is def our overall map of the data. For right now we are going to approach it as grid editable and also explore connecting another table and embedded it a report that way.
