Forum Discussion

MichaelMurphy's avatar
MichaelMurphy
Qrew Member
8 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
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
8 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....