Use two tables - one for well identification another for Comms Issues. Wells-- WellID - Autonumber - primary key Identifier - Text - fill in the complete location identifier (not just LSD). Description - Text Location - Text Physical Operator - Text Legal Operator - Text Remarks - Memo Comms Issues-- ErrorID - Autonumber - primary key WellID - Number - Integer - foreign key Open Date Status Pirority Working Interest Previous Day % Previous Hours Comments Close Date "Connie T." wrote: > Its like this, I am creating a database in which I am inserting different > well locations and each of the communication errors that occur. I have found > that the ONLY primary key that I can use is the LSD location (example > 6-36-064-09w6/00). I have created a table called Comms Issues, which > includes the following fields: > Location > Physical Operator > Legal Operator > Open Date > Status > Pirority > Working Interest > Previous Day % > Previous Hours and > Comments. > > The problem I run into, as I am inserting previous data from months past, is > usually one well will have only one communications problem per day, but they > definitely have more than one communication problem all together (example 1 > years time). Access will not let me insert the same well twice in one table, > how do you suggest I get around this problem?