Hi Garry
>Thanks so much for your quick reply. Is the purpose of the master test table to allow me to have multiple tests? Secondly, I thought I would need a child table for the muliple choice answers. Is that right?
Yes, the master test table is to have multiple tests. Also, the "mtquestion" table below is one record per test answer. The "correct" field can hold a numeric value which equates to the proper selection on a multiple choice question.
Here is the structure again:
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))
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05