simple query

[sergiogroups]

If It have a table T_Contacts:

Name Gender FamilyID
John M 1
Paul M 2
Anna F 1
Kate F 2

And want to create a table T_Couples:

Husband Wife
John Anna
Paul Kate

which is the query to do that?

 

[Joseph Meehan]

If It have a table T_Contacts:

Name Gender FamilyID
John M 1
Paul M 2
Anna F 1
Kate F 2

And want to create a table T_Couples:

Husband Wife
John Anna
Paul Kate

which is the query to do that?

I am not sure you want a new table. You have a table with the
individuals, all you need do is to provide the relationships to the existing
people you already have.

I believe there is an example of this kind of join in the Northwind
example that comes with Access.

 

[David Cox]

One way to do it is add a field id_partner and set it equal to the id of the
partner.