My very earliest surviving project was what started out as a simple address book of my personal contacts. Originally an Appleworks file, the data has evolved and still lives inside an Access application. For quite a while I've thought that it would be great to link individuals by pairs of relationships.

So far all I have set up is a table to define these relationships.

Definition Converse Category
-------------------------------------------------
Brother Brother Personal
Landlord Tenant Professional
Parent Child Personal
Doctor Patient Professional
Spouse Spouse Personal
Husband Wife Personal
Wife Husband Personal
...

Each of these will link two "people" records. Some of these are reversable (Spouse) others are directional.

More to follow...