> I am using Access 2000.
> I created twp databases that are linked by one field. The
> first db is called "MDO" - the 2nd is "ECR", they are
> linked by one field [MDO], which is also the primary key.
> The primary key in the ECR DB is the [ECR] field. Both
> fields are considered "text" fields.
> I created a form to enter in the infomation for the MDO
> Db. I created a 2nd form to take part of the information
> from the MDO db and add additional inform that goes into
> the ECR Db.
> As long as I enter information in the ECR form by calling
> up the MDO information first - everything works well. But
> I noticed that I could not add a new ECR form without the
> MDO information.
> So I created a 3rd form strictly from the ECR Table to add
> information into the ECR Db that did not require the MDO
> information. But I could not add new records. I keep
> getting a message that I am adding duplicate values in the
> index, primary key or relationships. But I have no
> relationships in this new form. In fact, I deleted all
> the relationships from the Db > Tools > Relationships.
> This form is based on the the ECR TAble Query and the
> primary field is an automatic number field. I do not
> enter that piece of information.
> When I looked at my ECR table in database view, I found a
> column at the beginning of the database that included
> small "plus signs" in front of all of the records. I
> don't know where this came from and I can't see to delete
> the column. But I have been playing with this problems
> for two days now and who knows what I have done.
> Does anyone know what the "plus signs" mean. Can anyone
> offer any suggestions????????