C
Connie T.
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?
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?