How do I enter data drawing from Field1 and have it use data of Fi

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm awfully new to Access so tell me if I'm not thinking right.

I'm using a form to enter data into a table. I use 1 table to draw info
from. They are service ratings, 1=Poor, 2=Mediocre, 3= Stupendously
Magnificent (quite the jump huh). I want to hit 1,2,3 but have it enter
Poor,Mediocre,Stup...into the Table2 as I add entries. What is the best way
to go about this? My purpose is to query it later.

Table1 = Field1(ID), Field2(Service) <- this table just has 3 rows for the 2
columns.
Table2 includes all manually entered data and roughly 10 fields named
Responce to Responce9 that holds the info I typed in my Form.

Thanks much, if I did not make myself clear just ask.
I am using Access 2000
 
I'm awfully new to Access so tell me if I'm not thinking right.

I'm using a form to enter data into a table. I use 1 table to draw info
from. They are service ratings, 1=Poor, 2=Mediocre, 3= Stupendously
Magnificent (quite the jump huh). I want to hit 1,2,3 but have it enter
Poor,Mediocre,Stup...into the Table2 as I add entries. What is the best way
to go about this? My purpose is to query it later.

Table1 = Field1(ID), Field2(Service) <- this table just has 3 rows for the 2
columns.
Table2 includes all manually entered data and roughly 10 fields named
Responce to Responce9 that holds the info I typed in my Form.

Thanks much, if I did not make myself clear just ask.
I am using Access 2000
Click to expand...

You may want to consider a different approach. If you have a one
(respondant) to many (responses) relationship, DON'T use multiple
fields; use multiple *records* instead! "Fields are expensive, records
are cheap" is an old saying around here. Suppose someday you need to
add an eleventh question - you'ld have to redesign your table, all
your queries, all your forms, all your reports. Yuck!

Much better would be to have FOUR tables not two:

RatingTypes
RatingTypeID
Description <e.g. "Promptness", "Clarity", ...>

Rating
<your current 1/2/3 table, that's fine>

Respondants
RespondantID <your customer ID, whoever's rating the service>
<information about that person>

Answers
RespondantID <a number, linked to Respondants: who responded>
RatingTypeID <a number, linked to RatingTypes: what issue>
Rating <a number, 1, 2 or 3, how good was the service>
<maybe a field for comments or the like>

You would not look at the table datasheet for the Answers table for
anything other than debugging: it's human-unreadable, with rows like

318, 2, 3
318, 3, 1

Instead you would use a Form with Combo Boxes which *DISPLAY* the text
"Promptness" or "Mediocre", but actually store numbers into the table.
The Form toolbox Combo Wizard will help you set these up. On a printed
Report you'ld use a Query joining all four tables so you can link the
"3" in the Answers table to the text "Stupendously Magnificent" in the
Ratings table, and print the latter.

John W. Vinson[MVP]
 
Back
Top