Great community. Great ideas.
Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.
February 19th, 2013, 07: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, 07:55 PM
this is a link to the accdb file hopefully it works fine any help is greatly appreciated
February 20th, 2013, 08: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, 11:56 AM
yeah bot tables have a primary field here is a link
By DevAdmin in forum Development Articles
Last Post: October 13th, 2010, 08:00 AM
By HJLatorre in forum Microsoft Access Help
Last Post: June 7th, 2009, 08:47 PM
By MrQuakers in forum Microsoft Access Help
Last Post: October 4th, 2007, 09:46 PM
By arcplus in forum Microsoft Access Help
Last Post: May 31st, 2005, 08:38 AM
By tkbell in forum SQL Development
Last Post: September 21st, 2004, 11:55 PM