Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    2

    Unanswered: Someone please help clarify things before i rip my eyes out

    First of all i would like to say i would be extremely grateful if someone can help me out. thanks in advance.

    Right my problem is the relationships in my access 2007 database. It's essentially a nursery system, registering parent and child info, staff details, creating sessions at different sites with different groups and so on. im 90% sure i have all the foreign keys right in my tables, but every single relationship is a one to one . so something's wrong.

    take my parent and child tables for example. i have in my head that.

    One parent has MANY children.

    so in my child table i have a parent ID from the parent table but when i drag the relationship it's 1 to 1 i will put a screenshot up of all my tables on relationship view but not linked.

    http://img691.imageshack.us/img691/5051/dbrelation.jpg

  2. #2
    Join Date
    Aug 2009
    Location
    Up Nort' Wi
    Posts
    140
    Check and make sure in your child table, the index for the ParentID is set to allow duplicates.

    Sam, hth
    Good, fast, cheap...Pick 2.

  3. #3
    Join Date
    Apr 2010
    Posts
    2
    it worked, thank you sam you diamond do i need to do this for all others too?

Posting Permissions

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