Update Query

[brsawvel]

Hello,

I have a form with the following fields:

fldAutoNumber - Auto Number - TextBox - PK
fldYear - Number - TextBox
fldSurveyName - Text - TextBox
fldQuestion - Text - TextBox
fldAnswerType - Text - TextBox
fldWritten - Memo - TextBox
fldSelect - Text - ComboBox
fldMultipleChoice - Text - ListBox

I have a table with the following fields:

fldAutoNumber - AutoNumber - PK
fldYear - Number
fldSurveyName - Text
fldQuestion - Text
fldAnswerType - Text
fldAnswer - Memo

So my 2 questions are this:

1. I know I can create a query to update the table, but how do I get fldAnswer in the table to be populated with fldWritten, fldSelect, or fldMultipleChoice (only one of these 3 fields are visible and can be filled in at any time)?

2. Because fldMultipleChoice is a multi-select listbox, how do I have individual records created in the table if more than one value is selected from the listbox?

 

[MarkK]

It doesn't make sense to me that the questions and the answers are in the same table. It seems sufficient to store a question once, but presumably many people will take the survey, so for one question you will have many answers. This is true also of Year and SurveryName in the structure you've provided; there is no need to duplicate this information with every question.