doing a many to many with twice the same table

[stevenm]

Hi all,



it is my first post here as I am begginging in Access.

I have a database with people. I would like to create a subtable for people indicating the links between them (such as, brother, father, friend etc...)

I have created an associate table taking person1ID (as foreign key), person2ID (as foreign key) and relationship (a simple drop down textbox).

The problem I have is creating a query Is it does not seem to differentiate person1 to person2?

any help would be wonderful.

thank you

[ranman256]

The tPerson table has a ParentID field....
Comes from the tParents table
[ ParentID],[FatherID],[MotherID]

collect all children with same ParentID, gender will dictate Sister ,Brother.

[stevenm]

Thanks Ranman for your quick reply.

I am not sure this will work... I would like at the end having a subtable on tperson that shows all the other persons with whom he has a link.

It is more than just brother and sister, we can have cousin, firends, Girl friend, school friend etc....

thanks

[ranman256]

I just gave you the setup, youd build queries to determine relations.
otherwise youd have tPerson-> tPerson -> tPerson ,....to infinity.