Notices

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.

Thread: Help Creating a Relationship

Results 1 to 4 of 4
Share This Thread →
  1. #1
    Beelzeboul is offline Registered User
    Join Date
    Feb 2013
    Posts
    4
    Rep Power
    0

    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

  2. #2
    Beelzeboul is offline Registered User
    Join Date
    Feb 2013
    Posts
    4
    Rep Power
    0
    Supplier.accdb

    this is a link to the accdb file hopefully it works fine any help is greatly appreciated

  3. #3
    meratigoerr's Avatar
    meratigoerr is offline Contributing User
    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    58
    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.

  4. #4
    Beelzeboul is offline Registered User
    Join Date
    Feb 2013
    Posts
    4
    Rep Power
    0
    yeah bot tables have a primary field here is a link

    Supplier.accdb

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

Similar Threads

  1. Creating Website Templates: Creating Content
    By DevAdmin in forum Development Articles
    Replies: 0
    Last Post: October 13th, 2010, 08:00 AM
  2. Relationship Help
    By HJLatorre in forum Microsoft Access Help
    Replies: 3
    Last Post: June 7th, 2009, 08:47 PM
  3. Relationship Help?
    By MrQuakers in forum Microsoft Access Help
    Replies: 1
    Last Post: October 4th, 2007, 09:46 PM
  4. help with relationship
    By arcplus in forum Microsoft Access Help
    Replies: 1
    Last Post: May 31st, 2005, 08:38 AM
  5. Help With Many to Many Relationship SQL
    By tkbell in forum SQL Development
    Replies: 2
    Last Post: September 21st, 2004, 11:55 PM

ASP Free Advertisers and Affiliates