Create related records with a loop

[reynir]

Hi

My issue is this.

I have one table, Procedure to audit (id, date, fk_procedure (the procedure/area to be audited). Then I have another table, Questions to answer in the audit (id, question, id_procedure)Then I have another related table, which we can call Items checkced during internal audit. (id, fk_Question_id, answer, non-conformance, actions, corrective actions etc.)

Then I have a table, Procedures (id_procedure, procedure name, etc.).

What I am trying to do is:

When I conduct internal audits I want to create one or more records in the procedure to audit table. Then when I have selected what procedure is audited I want to click a button and create series of Items checked during internal audid based on the questions related to the procedure.

The Pseudocode (sauðakóði in Icelandic) may look like this:

create a new record in the procedure to audit table

select the procedure to be audited

press a button

create new records in the questions to answer table based on the questions related to the procedure

Does this make any sense to you?

Any help appreciated.

Regards,

Reynir.

[comment]

I got lost in your explanation. I think you are describing something like:

Questions >- Procedures -< Audits -< Items >- Questions

and you want to pre-create the Items records, based on the selected procedure's questions?

If so, you could find the relevant questions (by going to related records after selecting the procedure), import them into Items and replace the AuditID with the ID of the current audit.