onload questionnaire

[zeon]

I would like to write a generic form that could be used to present a
questionnaire. The questions would be in a secondary SQL data source table
called Questions that would hold questionID, question and formID. The
responses would be held in the main connection SQL table named Responses that
would also hold same fields as the Questions, and also hold a Response#.

I would like to display the Response table as a repeating table, and
pre-populate the rows in the table from the Questions table using an onload.
Does this sound doable in InfoPath? I'd like the reponses to be done via a
number of radio buttons that would all map to the Response# column.

Since I'm not a jscript expert, can anyone give me sample code to loop thru
the Questions table and populate the Responses table? Thanks!

 

[Clay Fox]

That is a great InfoPath form solution.

You should be able to just use a key field to link responses to questions in
your tables. That would simplify things.

You should be able to do it without code.

I would recommend the Database Accelerator package of web services from
http://www.qdabra.com. This would allow you to query and submit your data
very easily as well as identify the users of the form.

If you would like a demonstration of a similar form let me know.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com