Search results

I’m not creating empty records - I’m looking to save time by populating some of the fields in a set number of records. If any of the other fields remain unpopulated then I can easily pick up on that. I think that I shall create a table with the desired number of records etc and run an append...

I haven’t put it together yet except on paper. I’m thinking four related tables ie tblinterview (to which I want to add the batch), tblinterviewDate (dateID is fk in tblinterview), tblinterviewer, and tblInterviewee (both have ID FK’s in tblInterview). I just want to create 8x6 records each day...

An append query? But how do I add the 1,2,3,4,5,6 to the records and then repeat to get the eight sets? String of append queries?

There are eight or ten employees each of whom conduct six interviews per day. Interviewers are in a separate table linked via FK. Interviewees in another table and added ti the interview record via a combo box.

The nested loops us what I think will work. Last time I did one was in BASIC on a Spectrum😂

I guess that this shall require some sort of nested For Next loop? I want to set a number of iterations of six records. For example 8 or 10 sets of six records - each set to acquire an autonumber ID from a “set” table and each record to have a field in which numbers 1 to 6 shall be inserted on...

Greetings. I have managed to run some hobby Access databases with very little knowledge and a good deal of help from fora(?) such as this. UK retired.