To follow up on the relationship post, here is the final result:

I ended up with a very simple design that just allows roles to be defined for each person in a relationship. Since it would be impossible to define every one of these in advance, new [Role] list items can be keyed into the combo box and it will then be appended to the [Roles] table.

The table looks something like this: