Forum Discussion

MichaelMurphy's avatar
MichaelMurphy
Qrew Member
9 years ago

Copying multiple records from one table to another as separate records

This app is for a field audit. There are approx. 50 questions on the audit that never change. The questions are scored as "S", "U", "Y", "N", "NA". I currently hold the audit results in one large tabl...
Eric_J_Hansen's avatar
Eric_J_Hansen
Qrew Cadet
9 years ago
We could write a script for you that would take care of this. Contact me in the info in my profile if you are interested.

Otherwise, you would need to create the big formula with all the redirects which gets hairy pretty quick.
  • MichaelMurphy's avatar
    MichaelMurphy
    Qrew Member
    9 years ago
    Thanks Eric, my other avenue of thought is to fully normalize the table structure but then my dilemma is how to build an input form that presents all the questions with answer options but writes each question:score as separate records....
  • Eric_J_Hansen's avatar
    Eric_J_Hansen
    Qrew Cadet
    9 years ago
    You could create a button that generates the questions as child records (from a template, perhaps using the copy master detail tool) and then on the master record, display the child records in grid edit / editable view.