Results 1 to 2 of 2
  1. 08-20-2010, 01:07 PM #1
    ambika
    ambika is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    1

    foriegn key and relationship


    Hi,I am currently working on a project were I shud make use of access also. I have created all tables. My doubt is whtr I can add forieng key constraint after table creation. ALso I must have one-one mapping but access always set it as one-many by default.How will I change this mapping to one-one?Any kind of suggestions would be of great help.Thanks in advance
    Reply With Quote Reply With Quote
  2. 08-20-2010, 01:21 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    You should be aware that 1:1 relationships are not usual in true RDBMS systems.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. many-to-one relationship
    By reverze in forum Access
    Replies: 7
    Last Post: 07-14-2010, 10:03 AM
  2. Relationship
    By pcandns in forum Access
    Replies: 2
    Last Post: 04-01-2009, 09:32 AM
  3. Many-to-Many Relationship
    By Carolyn1 in forum Database Design
    Replies: 0
    Last Post: 09-25-2006, 02:04 PM
  4. Many to Many relationship
    By Marlie in forum Database Design
    Replies: 6
    Last Post: 08-18-2006, 01:49 PM
  5. MAY TO MANY RELATIONSHIP
    By fadone in forum Database Design
    Replies: 2
    Last Post: 12-20-2005, 09:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums