Data Duplication in Tables?

[Guest]

I have a task monitoring system that is related to staff members, and the
companies these tasks are linked to. Each Task is made up of;

Task_ID = Auto number
Task_Name = Txt
Task_Outline = Txt
Task_Deadline = Date DD/MM/YYYY
Assigned_Staff_member = Txt
UserName = Txt (Primary Key on another Table)
Company_Name = Txt

The problem I am having is that my database will not allow me to assign
multiple tasks to one company. A company can and will have multiple tasks
assigned to it, why wont my database allow me to do that? Initially the table
did have Company_ID set as its primary key and it was an Autonumber, so I
could understand why it wouldnt let me duplicate the company_ID. So I changed
the primary key to Task_ID, and tried again and it still wouldnt work. I
removed company_ID and entered Company_Name instead which is a txt form and
again it still wont work!!!

Can anyone help me???

 

[Brian]

I have a task monitoring system that is related to staff members, and the
companies these tasks are linked to. Each Task is made up of;

Task_ID = Auto number
Task_Name = Txt
Task_Outline = Txt
Task_Deadline = Date DD/MM/YYYY
Assigned_Staff_member = Txt
UserName = Txt (Primary Key on another Table)
Company_Name = Txt

The problem I am having is that my database will not allow me to assign
multiple tasks to one company. A company can and will have multiple tasks
assigned to it, why wont my database allow me to do that? Initially the table
did have Company_ID set as its primary key and it was an Autonumber, so I
could understand why it wouldnt let me duplicate the company_ID. So I changed
the primary key to Task_ID, and tried again and it still wouldnt work. I
removed company_ID and entered Company_Name instead which is a txt form and
again it still wont work!!!

Can anyone help me???

1. Posting vague descriptions like "it won't work" will not help you get
an answer! If Access is giving you an error message, please post the exact
wording and any associated number.
2. Posting the same request three times within 10 minutes will not get
you an answer quicker, it will simply annoy people and make it less likely
that you will get any answer.
3. Based on the vague description you have given, I am guessing that, if
you look at the field properties for Company_Name in the table design view,
you have got the "Indexed" property set to "Yes (No Duplicates)"

 

[Henro]

1. Posting vague descriptions like "it won't work" will not help you get
an answer! If Access is giving you an error message, please post the exact
wording and any associated number.
2. Posting the same request three times within 10 minutes will not get
you an answer quicker, it will simply annoy people and make it less likely
that you will get any answer.
3. Based on the vague description you have given, I am guessing that, if
you look at the field properties for Company_Name in the table design view,
you have got the "Indexed" property set to "Yes (No Duplicates)"

To be honest: I think his computer is a little bit wavery. One time it will
not allow him to duplicate data (Access), the other time it forces him
(newsgroups)

Probably his machine is suffering from MMS (Multilple Machine Syndrome)
causing behaviour that sometimes seems to be the opposite of the expected.

H.

 

[Guest]

Sorry the Post 3 times was by accident and was not an attempt to get your
attention any quicker. The 1st two times I entered the post it said there was
an error and the message was not sent. So when I entered the message the 3rd
time, the other two messages had been posted, despite the site saying there
was an error!!! So didnt mean to p*ss anyone off, Im sorry!!!

The message that was displayed was

"The Changes you requested to the table were not successful because they
would create duplicate values in the index, primary key, or relationship.
Change the data in the field or fields that contain duplicate data, remove
the index, or redifine the index to permit duplicate entries and try again"

Hope this is ok.

Sorry

 

[Brian]

Sorry the Post 3 times was by accident and was not an attempt to get your
attention any quicker. The 1st two times I entered the post it said there was
an error and the message was not sent. So when I entered the message the 3rd
time, the other two messages had been posted, despite the site saying there
was an error!!! So didnt mean to p*ss anyone off, Im sorry!!!

The message that was displayed was

"The Changes you requested to the table were not successful because they
would create duplicate values in the index, primary key, or relationship.
Change the data in the field or fields that contain duplicate data, remove
the index, or redifine the index to permit duplicate entries and try again"

Hope this is ok.

Sorry

:

Apology accepted. In fact, I just had a message to a MS Newsgroup bounced
as well for some reason.

Anyway, the error message confirms my earlier guess: either the company name
is the primary key on the table, or you've got a unique index on it. As
suggested before, have a look at the table and the field in the table design
view.

 

[Henro]

Apologies more than accepted. I am not being p* off, was rather having a go
at being funny, which is quite a challenge in my case.
In dec 2003 I was developing a database that was gonna be used starting 1st
of january 2004.
Hence I forwarded my clock to that date, forgetting to put it back when I
was posting. Some ppl actually waited to the 1st of january to respond to my
questions

As for your access problem: apart from suspecting your computer has MMS, I
think Brian is right in his conclusion towards your problem; it clearly is a
problem with the index of the company name. Set duplicates to 'allowed'.

As we say in the netherlands: he hammered the nail right on the head!

Grtz H.