Now it sounds like you want to add a sequence number as the interviewees are added to the table. It is almost always wrong to add "empty" records ahead of time. Are you getting a file of interviewees that you have to divide and assign to a specific individual? If so, then my original suggestion will work. If you are adding the interviewee records one at a time as the people come in the door (so to speak), then you will add a sequence number in the BeforeUpdate event of the form. No update query or code loop will be required.
DBGuy,
Queries can do one thing to every row of a recordset. They cannot do multiple "things". So a single query cannot both create a batch record in one table and then update some set of records in a different table with that new batch number.
If Squiddley is calling 1,2,3,4,5,6 and then repeat a "batch" that is different To me a batch means a way of grouping records arbitrarily such as the first six records are assigned to batch 1, the second 6 to batch 2, the third 6 to batch 3, etc. Using that concept, you first create the batch number record and save it (outer loop) and then assign that same batch number to the next six unassigned records.
I guess we'll need to wait for Squiddley's definition of "batch"