Link records both ways - as in a referral program

I am trying to link records in a single table to each other to manage a referral program.

Here’s what I’m trying to achieve:

Jim refers Beth, Bill, Jane.

In Beth, Bill, Jane’s records - you can see that they were referred by Jim.

In Jim’s record - you can see that he referred Beth, Bill, Jane.

Right now, I can only figure out how to reflect this relationship one way. So, Beth, Bill and Jane’s records reflect that they were referred by Jim. But, I am not able to figure out how to get it to show up in Jim’s record that he referred 3 people.


Check this out:

Perhaps his solution will work for you.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.