Welcome to ModelRight Database Design Tool - Database Modeling Done Right Sign in | Join | Help
in

Recursive Relationships

Last post 11-04-2009, 8:35 AM by mcscreech. 2 replies.
Sort Posts: Previous Next
  •  11-03-2009, 3:49 PM 1360

    Recursive Relationships

    Hello,

    I am having difficulty defining recursive relationships. I seem to have no control over where the connectors join the tables in the diagram. And when I try to shift the position of any one of them they ALL jump to odd (sometimes disconnected) locations. Suggestions?

    If an example is required I can attach a zipped model file subset to a followup post.

    Thanks, DaveT.

  •  11-03-2009, 5:36 PM 1361 in reply to 1360

    Re: Recursive Relationships

    I'm not too surprised.  Recursive rels were not designed to be moved.  Is that an issue for you?  If so, why?
    Scott Reynolds
    Technical Support Engineer
    ModelRight, Inc.
    www.modelright.com
    p: (609) 423-9296
    f: (866) 812-3742
  •  11-04-2009, 8:35 AM 1366 in reply to 1361

    Re: Recursive Relationships

    Just looking for more control over the diagram layout. I have a situation where there are three recursive relationships on a single table. It's a pedigree app where I have 'mother', 'father' and 'family' as FKs all linking to the PK 'id' of the same table. So, when they are all clustered around the same corner labeling becomes quite jumbled.