Jump to content

Im sure this has been asked 1000 times...


This topic is 5800 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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/

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

This topic is 5800 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.