creating a table without multiple entries

[talktobatchu]

There is some information regarding a disease for which the number of cases
and case rates are stored for each year and for all the counties in a state.
When designing a table for storing this information in Access, my table has
repeated values for the county names for each corresponding year for saving
the cases and case rates information. My table looks as follows:

(below are my column headings)
ID YearField CountyName Cases CaseRates
------------------------------------------------------------
1 1988 county1 90 12.5
2 1988 county2 65 9.2

after storing the data in the above format, the year values and county names
are being repeated. How can this kind of data be stored in access table(s)
without any redundancy or multiple values of same field.

thanks for any help.

 

[Duane Hookom]

You could create a table of County and Year combinations:
tblCountyYears
=================
cyrCyrID Autonumber Primary Key
cyrYear year value
cyrCounty County value

Then you can replace the YearField and CountyName with the cyrCYrID value.