Duplication???

[Guest]

I have a Task system for my Database, and it doesnt like assigning one
company many tasks. Each Task is made up of a number of things.

Task_ID = Auto Number
Task_Name = Txt
Task_Outline = Txt
Assigned_to_staff_member = txt
Company_Name = txt

I have a Table with all the company names in, and when there are 2 tasks
assigned to the same company name, it doesnt like it and says that cant be
done. Why not? A company could have many tasks assigned to it, it works fine
with teh staff members, and thier Id's. If one staff member can have multiple
tasks, one company should have multiple tasks!!!

The UserID's is a primary key, but doesnt have a problem with this
duplication. So why does the company_Name have a problem?

 

[John Vinson]

On Tue, 12 Oct 2004 02:17:03 -0700, Richard C <Richard

The UserID's is a primary key, but doesnt have a problem with this
duplication. So why does the company_Name have a problem?

Check the Company_Name field in table design view. Does it have a
unique Index (at the bottom of the screen in field properties)? If so
change the Index to "Allow Duplicates".

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps