February 19th, 2013, 08:49 PM
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, 08:55 PM
this is a link to the accdb file hopefully it works fine any help is greatly appreciated
February 20th, 2013, 09:31 AM
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, 12:56 PM