Open a table with blank records

[Dugantrain]

I have a form which has a subform based on a query. What I need here is to have the subform (in datasheet view) load with 40 records which have blank fields except for the autonum primary key (which will be invisible), as well as 40 items, one per record. The items are from the item table, but the foreign key corresponding to their Autonum should be bound. The blank fields will be for quantities picked up, quantities dropped off, total quantities, etc. The idea here is that users should be able to copy and paste these quantity numbers directly from an Excel spreadsheet rather than manually type in each cell to the subform/datasheet. This strikes me as a fairly simple task to ask the database to do, but I've yet to figure out how.

NOTE: I think I'm a little closer now. What I've done is created an outer join query so that all of the items will show up when the query is run. The subform loads all of these items OK, too.However, when I link the sub to the main form, only one blank record shows up rather than the 40 half-filled records.