Hi Garry ----

You'd want a master test table and a child table with one record for every question in a test. You'd also want a master client record with a child record for every response. That child record would also contain foreign keys linked to the test questions (test child) and master test.

IE:

CREATE TABLE mastertest (mtkey C(10),mtname C(40))
CREATE TABLE mtquestion (mtqkey C(10), mtkey C(10), quest C(50), correct N(1))
CREATE TABLE client (clikey C(10), cname C(50))
CREATE TABLE cresponse (clikey C(10),mtkey C(10), mtqkey C(10), answer N(1))

This is assuming that it's a multiple choice type of questionnaire. Any more questions?


>Does anyone know what would be a good database design for a questionaire application. It just needs to identify the information for a client and the answers to the questions asked, or if you can't suggest a good design, coul you tell me where I might find a book giving an example of how to program a questionaire in Visual FoxPro.
>
>Thanks in advance