Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-19-2005, 06:24 AM   #1
rnimchuk
Guest
 
Posts: n/a
Table Setup For Survey DB Using Multiple Sets of Questions

Good morning,

I am having problems figuring out how to set up my table/query structure for a series of surveys that are based on specific user groups. In a nutshell how do I set up the relationships for the Questions, Employees, and Answers if I have the following tables (simplified):

tblQuestions
--------------------
QuestionID (P)
UserGroupID
Question

tblEmployees
--------------------
EmployeeID (P)
Name
UserGroupID

tblAnswers
--------------------
AnswerID (P)
QuestionID
EmployeeID
Answer

The functionality requirements are:

1. Create a set of questions for two or more user groups (each set contain different questions).
2. Assign Employees to a specific user group.
3. Employees are able to enter the DB to answer the questions within their user group.

What should happen is the employee accesses their set of usergroup questions and enter the corresponding answers. Each time I try to set up the relationships however, the answer field ends up being uneditable.

Any help you can give would save what little hair I have left.

Thanks!

Bob


Last edited by rnimchuk; 09-19-2005 at 06:27 AM.
  Reply With Quote
Old 09-19-2005, 06:32 AM   #2
KenHigg
Registered User
 
Join Date: Jun 2004
Posts: 13,306
Thanks: 8
Thanked 155 Times in 129 Posts
KenHigg has a spectacular aura about KenHigg has a spectacular aura about
Bob,

Welcome to the forum!

This type of DB has been discussed quite extensively around here. You might get some good ideas from doing a search on the topic.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

ken

“You don’t learn to walk by following rules. You learn by doing, and by falling over.”
KenHigg is offline   Reply With Quote
Old 09-19-2005, 10:42 AM   #3
rnimchuk
Guest
 
Posts: n/a
Thanks Ken, that is what I have been doing for the last 30 minutes or so.

I now understand I need to use an Append Query. I am now trying to figure out the best way to incorporate it into my DB.

Thank You!

  Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to connect to current table within a loop while importing multiple spreadsheets cnVivian Modules & VBA 2 09-17-2004 10:43 AM
[SOLVED] Table Setup & Auto feature leeegglestone Tables 1 08-12-2004 10:55 PM
Display multiple records on same table ErikRP Forms 5 02-06-2003 08:54 AM
Multiple Forms from 1 table 2000TransAm Forms 3 06-19-2002 08:23 AM




All times are GMT -8. The time now is 02:09 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World