Jump to content

Contact Link to Contact

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

Recommended Posts

  • Newbies

What I would like to do is link contacts to contacts with a specific role attached. The example would be a family signing up for services, I'd like to say enter the mom, dad, and kids and then link the mom & dad to the kids so when you look up the dad/mom you'd see they are connected to the kids.  Additionally, I'd like to add the role, so in the case it would be 'mother' or 'father' of the connected contact.

When I tried to take the 'add connected contact' from another tab (say account table) it says it isn't related.  But the question is, since I am linking a contacts table to itself, how would this work?


Edited by xfiring
Link to comment
Share on other sites


There isn't exactly a "simple" way of doing this. But here is what I would do:

1.) Create the following fields in the "Contact" Table (File --> Manage --> Database while in the contacts module):

     -  ID_Family: a number field, after created select the field, select "Options"(Bottom Right) and select Serial Number "On Creation"

     -  Family_Name: Just a test field

     -  Relation: Another text field

2.) Create a relationship from CONTACTS to CONTACTS based on the field ID_Family:

     -  File --> Manage --> Database -->Relationships

     -  Press the "Add" button (Bottom Leftmost button)

     -  Select CONTACTS from the list

     -  Draw a line (by clicking and dragging) from ID_Family in the contacts Table Occurance you just created to ID_Family in the Contacts Table Occurance that already exists in the graph. (You can scroll through existing fields by pressing the little arrow at the bottom center of the TO)

3.)  Copy Script "(0602) Relating an Account" (File --> Manage --> Scripts, find the mentioned script, and press "command/Ctrl" + "D")

4.)  In the Script copy, double click line 11

5.)  Select "Specify" on the Value Line

6.)  Replace the value "T05_CONTACTS::id_account" with your new field "ID_Family" by highlighting "T05_CONTACTS::id_account" and then selecting "ID_Family" from the list on the left.

7.)  Change line 14 from (0300) to (0303)

8.)  Save your Changes

9.) Anytime you want to relate a family, run this script and select the person they are related too.





Jonathan Hogle


Link to comment
Share on other sites

  • 11 months later...
  • Newbies

Thanks Jonathan, sorry to bring this back up but this worked till I got towards the bottom and the options were different than what was in FM starting point.  I am on FMSP 5 and would still like to accomplish this or look at how involved it would be to create links (many to many), one person can be linked to other people.  Kind of like Seedcode's John is associated with as his father and then Erick is associated with John as his son.

Link to comment
Share on other sites

Hello xfiring,

This may be a little much to cover strictly over text. Why don't you email us at [email protected], and we can talk to you about some different options available to get this all sorted out.

Ask for me personally, and I'll make sure we help you out the best we can.


Jonathan Hogle

Link to comment
Share on other sites

This topic is 1539 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

  • Similar Content

    • By Richard Carlton
      FM Starting Point 7 has some Quickbooks integration built into it!  This full livestream recording explains how Quickbooks has been integrated into our free CRM and how this can benefit you and your business.  For more great live training, visit FMTraining.tv/#LIVE to see our broadcast schedule.
      [email protected]
    • By DevDude
      I search but can't seem to find the answer to this one. Here are some of the searches I tried which may help others find this message.

      Can I change the FM Starting Point file name to something else?
      Rename FM Starting Point

  • Create New...

Important Information

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