Drop down menus appearing in tables where not wanted

[fllopez65]

I have attached my database called survey. I have 3 different but I think related problems. First, when opening the survey questions table an"Enter Parameter Value" box appears, asking for Survey responses.Respondent ID. Respondent ID was that was deleted as I thought it was not required.Clicking ok, gets rid of it.
Second: In the first question of the survey questions table-Would you be interested in Online grocery shopping, the answer should either be yes or no, instead it is has a drop down menu which for some reason is linked to all the responses for all the questions. I tried changing the data type for the first question to yes/no. The result was the same, the same drop down menu appeared.
Third: In the Survey response questions table-in the first response:Would you be interested in Online grocery shopping, the answer should either be yes or no, instead it is has a drop down menu which for some reason is linked to education table options.
I have tried everything I know to fix these 3 problems but nothing is working.
Any suggestions would be greatly appreciated.
fllopez

 

[Mr. B]

All of your issues were related to the fact that there were "Lookup" options defined for the two field that you said were presenting information from other tables. These lookup definitions had to be removed before the field type could be changed. I have removed the lookup definitions and the fields are now set to Yes/No type fields.

 

[fllopez65]

Mr.B
Tks for your help. I will redownload the adjusted database asap and relook at it.

Sorry, one further question: As you notice in my db, my survey responses had fields with multi-field values ie: education, income. If I wanted to get an average or the medina of the income level responses,what kind of query would you use? I would like the query output to show for example: "average education leve"l: Undergraduate degree.
tks
fllopez65