Ok sorry everyone for being so clueless but I just got into filemaker, I did a search on a few different topics about this but couldn't find any answers...Anyway here goes.

I have a database that has people's information in it. Say two people are entered into the database and they are best friends. I want to be able to link them so that they are connected. What I am trying to do now is create a script that is sort-of a perform find of their best friend where I can jump to that person's "profile" or record.

Here is a little scenario. Travis has a best friend Jon. I enter both Travis and Jon into the database and each has their own record. In Travis' record Jon is his best friend and in Jon's record Travis' is his best friend. I want to have a script ( a button) that i push while viewing Travis' record to jump to Jons record and vice-versa.

Right now in the database I have a field called "best friend" that I enter the name of the person's best friend. So I need a script that...checks the "best friend" field of the current record i'm on preforms a find for that name in the database (would probably reference the "first name" field), then takes me to that record.

I know this might not be the best way of linking two records in the database but it was the only way I could think of doing it. If there is a more simple way of doing this please let me know.

Thanks in Advance

The solution may depend on if the relationship from Jon to Travis always implies a relationship from Travis to Jon. Jon may be Travis' best friend, but does that mean that Travis is Jon's best friend?

Check out these threads for past discussions on this type of real-world relationship tracking:

http://fmforums.com/forum/showtopic.php?tid/171427/

http://fmforums.com/forum/showtopic.php?tid/135019/

The solution may depend on if the relationship from Jon to Travis always implies a relationship from Travis to Jon. Jon may be Travis' best friend, but does that mean that Travis is Jon's best friend?

Check out these threads for past discussions on this type of real-world relationship tracking:

http://fmforums.com/forum/showtopic.php?tid/171427/

http://fmforums.com/forum/showtopic.php?tid/135019/

Thanks for the links although they might be a little to complicated for what i'm doing. In the scenario I proposed between Jon and Travis, they can only be one another's friend.

In Jon's record Travis is his best friend and in Travis' record Jon is his best friend. There are no other options. In other words you HAVE to be best friends with whoever is best friends with you.

Is it still complicated in this case?

Basically, (I think) I just want to perfom a find of the name that is in the "best friend" field

Does this mean they can't have any other friends?