Jump to content

Create related records with a loop


This topic is 4367 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 4367 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.