Association between two People TO

[Russ_D]

I am trying to create a many to many relationship with a join table between two People TO and able to view through a portal from both sides. Also need to describe the association from both sides.

[T-Square]

Table People:

PeopleID Auto-enter serial number

LName

...

Table PeopleJoin:

JoinRecID Auto-enter serial number

ParentID

ChildID

Relationships:

People::PeopleID <-> PeopleJoin::ParentID

People::PeopleID <-> PeopleJoin::ChildID

Does that help?

David

[comment]

See also:

http://fmforums.com/forum/showtopic.php?tid/171427/all/1/

http://fmforums.com/forum/showtopic.php?tid/177247/