I have a contact list where one of the fields is “Referred to…” to show how I got into contact with someone. What I want is a two-way link for “Referred to/by”, like so:

   Name   | Referred To | Referred By

---------------------------------------

    Jim   |     Amy     |  

    Amy   |             |   Jim

    Bob   |             |

For example, if we have three names in the table, eg.

Jim

Amy

Bob

Jim introduced me to Amy, so have it as

Jim | Amy

Amy

Bob

The problem is, when I link Jim to Amy, I want another column that shows that same relationship in reverse, a “referred by…” field. So it would look like:

   Name   | Referred To | Referred By

---------------------------------------

    Jim   |     Amy     |  

    Amy   |             |   Jim

    Bob   |             |

So far, I’ve been unsuccessful at doing this. I’ve tried using Lookup but it only finds itself.

Any ideas?