Results 1 to 2 of 2
  1. #1
    SANEEHA is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Nov 2013
    Posts
    1

    how to create one to many relashionship in Acces 2003

    i have three tables in access:



    Hospital
    Doctor
    patient

    I nedd to creeate one to many relashionship between :

    hospital and ptient
    and
    hospital and doctor

    When ever i create relation ship between the primary key of hospital and the same key as foreighn key in patient table, the relation ship window soesnot give any option of one to many relationship...

    please help...

  2. #2
    drunkenneo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    199
    While creating it Check the check boxes of Enforce Referential integrity and other checkboxes for to see the relationship.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import multiple txt files acces 2003
    By soli004 in forum Import/Export Data
    Replies: 3
    Last Post: 09-18-2013, 02:46 AM
  2. Acces 2003: Import Form
    By compooper in forum Import/Export Data
    Replies: 4
    Last Post: 06-22-2011, 02:51 PM
  3. Acces 2003 MUI error
    By coudu in forum Access
    Replies: 0
    Last Post: 03-15-2010, 04:53 AM
  4. Replies: 1
    Last Post: 03-10-2010, 04:53 AM
  5. acces listbox hatası(acces debug)
    By carso in forum Access
    Replies: 1
    Last Post: 09-22-2009, 04:11 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
  •  
Other Forums: Microsoft Office Forums