Field Name problem

[Merv]

I have an Access file that I need to name fields as follows:
1A, 1B, 1C, 2A, 2B, 2C, ..... 51A,51B, 51C, 52A, 52B, 52C.
These fields represent three values for each of the 52 weeks in the year. When I try to save the Table I get a message stating that I cannot have duplicate entries. There are no duplicate entries.


What is the problem and what is the solution?

[jzwp11]

I'm not sure what the naming problem is but the table structure is incorrect. The values you intend to store in the fields (1A, 1B, 1C, 2A, 2B, 2C, ..... 51A,51B, 51C, 52A, 52B, 52C) should be records in a table rather than in fields within 1 record. You have a many-to-many relationship between the week number and the 3 values (A,B,C). That should be represented with 3 tables

tblWeekNo
-pkWeekNoID primary key, autonumber
-WeekNo

tblValues
-pkValueID primary key, autonumber
-txtValue

tblWeekValues (this is the junction table)
-pkWeekValueID primary key, autonumber
-fkWeekNoID foreign key to tblWeekNo
-fkValueID foreign key to tblValues
-thingyouwanttostore