how to do this???

[phool4fool]

I'm working on a questionnaire db & in this db, I've Question table where there answer will be "Yes/No/Don't" Know and another table Other Questions where the answer will be "Yes/No" only.


There will be also another table where I'll put questions where user has to input the answer.
I just find this way to hand these type of question but don't know if there is a better way to do that.
I want to show all questions and answer next to them on a single form & for this I joined tblQuestions & tblOtherQuestions which worked fine but the only problem is when I join these two question tables... I see Answer field just as text field... when on seperate queries it shows normal like a combo field in query.
Can you please guide me how to solve this issue.
I've attached db here.

[June7]

A UNION query is not updatable - cannot edit data through a UNION query, can only view data.

Don't do data entry on tables, use forms.