linking records in a form to one another

[Guest]

I want to link records within the same form to one another. For example, I
have a table of contacts. We'll say one of them is named John and his record
contains all of his contact details. One of the items listed on the form is
Referrer, where the name of the person who referred John to us is listed
(let's call him Tom). I would like to create a new record for Tom, the
referrer, with his contact info in the same table. Is is possible to create
a link so that clicking on Tom, John's Referrer, takes me to a new record in
the same table for Tom himself? It's my understanding that creating a
subform wouldn't permit the table to recognize the records as being equal
ones? Thanks for any help.

 

[Guest]

From my way of thinking I think you can.

Create a query using the table as the source and use the query as the source
for a combo. When you select the name store the ID and use a command button
to search for another record equal to that ID.

That way you can store all the names in the same table. In the criteria of
the query exclude the current record (you dont want someone referring
themselves)