- Total Members: 220,018
- Threads: 525,385
- Posts: 976,987
-
February 19th, 2013, 07:49 PM
#1
Help Creating a Relationship
So I am currently taking intro to database and am having a very difficult time creating a relationship I have checked fields but keep getting an error when I go to create stating (no unique index found)
I have double and triple checked all my fields and captions to ensure they are correct and can only assume that I must have clicked yes or no improperly in a prompt what bothers me is even though the CompanyID is labeled as Primary key in the company table it does not receive the key next to the field I'm including my accdb so far and the exact task is to create a one-to-many relationship between the product and company tables it does not stipulate but the only field shared is the companyID field so I assumed that was my target any help would be greatly appreciated....I'm not seeing a paperclip option in the new thread icons to attache so if anyone could help me with that first I guess it would get me rolling
-
February 19th, 2013, 07:55 PM
#2
Supplier.accdb
this is a link to the accdb file hopefully it works fine any help is greatly appreciated
-
February 20th, 2013, 08:31 AM
#3
If you're joining two tables do both tables have a primary key field set?
New users cannot post attachments. Use a file share site such a box.com and post the link to your file so we can take a look.
-
February 20th, 2013, 11:56 AM
#4
yeah bot tables have a primary field here is a link
Supplier.accdb
Similar Threads
-
By DevAdmin in forum Development Articles
Replies: 0
Last Post: October 13th, 2010, 08:00 AM
-
By HJLatorre in forum Microsoft Access Help
Replies: 3
Last Post: June 7th, 2009, 08:47 PM
-
By MrQuakers in forum Microsoft Access Help
Replies: 1
Last Post: October 4th, 2007, 09:46 PM
-
By arcplus in forum Microsoft Access Help
Replies: 1
Last Post: May 31st, 2005, 08:38 AM
-
By tkbell in forum SQL Development
Replies: 2
Last Post: September 21st, 2004, 11:55 PM