Database setup on form?

[dbrooks]

I've setup a survey database with about 50 questions. I'm curious as to how I can create a form that will work with my database. I have 3 tables, 1 employee table with a primary key as an employee id. 2nd table is just a lookup table with all the questions in it (so just 2 columns), then a 3rd table which link the first two tables together which employees will go in put in their employee_id and for each record it will have a/an employee_id, and a question, (and of course an answer). So the question field is a combo box off of the 2nd lookup table. Any ideas??? Thanks so much.

 

[crosmill]

Hi there, I'm not really sure exactly what you want to do here but I've just finished creating a questionaire using Access, I think your trying to do a similar thing???

 

[dbrooks]

yes, that's exactly what I want to do, I would like to see how you setup the form, so that your can see multiple questions at once. -db

 

[crosmill]

It hometime in the UK now, but I'll post back tomorrow

 

[dbrooks]

Excellent, Thanks very much!

 

[crosmill]

hi there, OK firstly I think you have your tables set up incorrectly. you need your employees in one tables, with the primary key, and you need another table with a field for each answer and a field for the key to link on, set up as one to many, employees to answers.

The way I collect data is to have a form and subform, the form would have the employees and the subform the answers. I have the subform set up as tab pages so your not opening new forms all the time.

I hope this is enough information to get you started, I can email you screen shots if it'll help, just send me an email.

HTH