Create multiple new records in a table

[rmorrison]

Hi, I have searched through many posts to find the answer to this, but
none seem to help:

I have a 3 tables: clients, certificates and audits. Each is a one-to-
many relationship. I can create certificates for each client, but I am
struggling to create seven audit records for each certificate. I need
to be able to create a new certificate record and have Access create
the seven audit records in one go. At present, I have to create each
audit record individually.

Is it possible?

 

[John W. Vinson]

Hi, I have searched through many posts to find the answer to this, but
none seem to help:

I have a 3 tables: clients, certificates and audits. Each is a one-to-
many relationship. I can create certificates for each client, but I am
struggling to create seven audit records for each certificate. I need
to be able to create a new certificate record and have Access create
the seven audit records in one go. At present, I have to create each
audit record individually.

Is it possible?

Is it necessary?

Creating empty "placeholder" records essentially NEVER is!

If you have a really, really good reason to do this that I don't understand,
then you can use an auxiliary table. I routinely include a table named NUM
with one field N, with values from 0 through 10000 or so. An Append query
based on Num with a criterion on N of

< 7

will have seven records; if you include a form reference or a single
certificate record in the query with no join line, it will be repeated seven
times.

John W. Vinson [MVP]

 

[rmorrison]

Is it necessary?

Creating empty "placeholder" records essentially NEVER is!

If you have a really, really good reason to do this that I don't understand,
then you can use an auxiliary table. I routinely include a table named NUM
with one field N, with values from 0 through 10000 or so. An Append query
based on Num with a criterion on N of

< 7

will have seven records; if you include a form reference or a single
certificate record in the query with no join line, it will be repeated seven
times.

John W. Vinson [MVP]

Hi,

Basically, each client will have 7 audits for each certificate they
hold. The dates for these are set in advance, so I need the 7 fields
ready for dates to be entered. If I use an auxiliary table, as you
suggest (and I know this is a dumb question) how do I do it?

Thanks

 

[John W. Vinson]

Hi,

Basically, each client will have 7 audits for each certificate they
hold. The dates for these are set in advance, so I need the 7 fields
ready for dates to be entered. If I use an auxiliary table, as you
suggest (and I know this is a dumb question) how do I do it?

Thanks

No. You do NOT need to have an empty record in a table in order to enter a
date.

Just use a Subform for the audits table, *and enter the dates*. It is not
necessary to do so in two steps; the subform will let you create records
whenever you have data (a date) to put into the record.

I can imagine a case where you might want to run an Append query to append a
fixed set of dates into the table - where do these dates get assigned?

John W. Vinson [MVP]