I want a form to populate a questionnaire and empty the answer field

[cas99]

We are working with a form to serve as a questionnaire (answers will be text). Currently our form is linked to one table containing both Question and Answer fields, among others. We want to have more than one user answer the same question. The Question field is populated from the table and locked for editing and the Answer field is currently empty. Each time a new user pulls up the form, we would like to populate the Question from the Question field in the table, but clear out the Answer from previous users (unless a previous user is re-entering then we would like the previous responses to come in). Currently we can get our form to either populate both the Questions and previously entered Answers or leave both blank. Is there a way to have the form create another set of Answers which still link to the questions?

 

[Rohdem]

Can you elaborate on how your tables and relationships are set up? Mike Rohde
rohdem@marshallengines.com

 

[cas99]

Currently we have 1 table “Questiontest” that contains all of our information fields (Name, Job Title, Site, Question, Answer). We have a form with buttons that filter the questions based on the button chosen (Job Title), so only the questions related to their job are shown. Upon choosing a button, a separate form opens for data entry (name, answer). This data entry form looks up the filtered questions from the “Questiontest” table and populates the “questions” field in the form. When answers are typed in text box to the side of the text box containing the question, they are being sent to the same table the questions came from.

We have actually tried to set our tables up various ways. In my initial question, there is just the one table involved – thereby no relationships with other tables. We have also tried to make our form work by setting up 2 tables (one to many relationship) – one table has Name, Site and Job Title, the other table consists of Name, Job Title, Questions and Answers. The purpose of the form that we are trying to develop is to survey individuals based on predefined Questions by Job Title and store those Answers by the Name and Site of the person answering the questions.

 

[Rohdem]

How about this? Create a new table with just questions, job titles, and sites. Have an initial form that the user enters the job title, site, and name. Based on this information, put the proper questions into a second table that contains name, question, answer, but leave the answer field blank. Then open a form based on the second table that filters for the persons name. Mike Rohde
rohdem@marshallengines.com