Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    relationship tangle (a2k)

    I've a table relationship tangle I need some help with. I'm trying to set up an order system that allows unaffiliated individuals to place orders and people associated with organizations to place orders. I've attached the relationship diagram.

    As soon as I add people associated with organizations, i.e. the link between tblOrder and tblConsOrg, I disable the ability to link directly between tblOrder and tblConsumer. I get the dreaded you can't add or change a record because a related record is required in tblConsOrg.

    Is there anyway around this? If it were you, how would you handle it?

    E
    Attached Images Attached Images

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: relationship tangle (a2k)

    The most pragmatic approach is to disable referential integrity between tblOrder and tblConsOrg - in point of fact you indicate that there can be people who are not associated with a Consumer who place orders.
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: relationship tangle (a2k)

    perfect

Posting Permissions

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