I realise that this duplicates data within my database however, without going into length details, this is actually necessary.
Having discussed this design with you, I don't agree. I see no need to duplicate this data. Since you have a relationship in place, you can add fields from the QIP Steps table to your Inspection Results table and they will display the needed data without any need to store the same item and description data a second time. All you need is a looping script that loops through the QIP Steps table, to use their QStepID number to create matching records in Inspection Results for the new inspection.
It would help to include a link to your previous thread when you start a new one like this. Then people interested in helping can refer back to it to get the full picture of your design set up. I am assuming from the reference to a QSTEPID field that you are attempting to implement the table structure I recommended in that thread, which involves more than the two tables you've mentioned here.
To copy data, such as QStepID from one layout to another you can use a script similar to this:
#This is a partial script, steps to capture the desired Report ID in $ReportID and Performing a find or using Go To Related Records
#to pull up the needed found set of QIP Step records should precede these steps...
#Perform this loop on QIP Steps layout after pulling up needed set of step records for new inspection
Go To Record/request/page [first]
Set Variable [$ID ; QIPSteps::QStepID ]
Go to Layout [Inspection Results]
Set Field [Inspection Results::QStepID ; $ID ]
Set Field [Inspection Results::ReportID ; $ReportID]
Go To Layout [QIP Steps]
Go To Record/Request/Page [next ; exit after last]
Thanks Phil, having reread yesterdays and your post above, the lightbulb finally went off regarding QstepID. (I warned you I'm a little slow on the uptake). I actually reformatted my tables and relationships exactly as you proposed. When I typed the post I did not have the correct name handy.
Once again thanks for your help and support, if I have any more problems with this I will repost on this thread.