#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    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
  3. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    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
  4. #3
  5. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    59
    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.
  6. #4
  7. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Feb 2013
    Posts
    4
    Rep Power
    0
    yeah bot tables have a primary field here is a link

    Supplier.accdb

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

IMN logo majestic logo threadwatch logo seochat tools logo