Jump to content

Complex Relationship Help


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

Recommended Posts

For my business, I have a lot of people who refer clients to me for credit assistance. When a person signs up, we note who referred them.

I want to be able to look at any client, and not only see who referred them, I want to know about the people who referred before them.

Example, John is a Loan officer, and refers Bob. Bob then refers Chris.

I want to be able to look at Chris, and see Bob, and John, and some details about them. Since all of our clients are asked to refer business, this would have to be some kind of relationship to show the previous 2 referers in the line. Where it gets complicated is, if the person who referred them is not a client of ours, they are kept in a seperate database called "Agents" I've got to be able to see data from both places at the same time.

Any suggestions?

Sorry for the complicated explanation.

Thanks in advance

FileMaker Version: Dev 6

Platform: Windows XP

Link to comment
Share on other sites


I took a few minutes to adapt a file I posted a few months ago about Multi-Levels relationships.

The original was building a tree from the Main parent to the Last, while in your Case, you'd go backwards into the tree.

The Ids are kept stored in either a Multiline Key and a MultiKey so that you can easily use these keys lately to link and see all related referers.

In my opinion, you'd better use only one Contacts file and classify your contacts as either Customers or Agents.

If not, at least use an external file with all of them, so that you can lately grab the ID and go back to either the Customer file or the Agents file second which category the record belong to.

FileMaker Version: 6

Platform: Mac OS 9


Link to comment
Share on other sites

Thanks Ugo! Looking at this file has made me realize that I still have a LOT to learn about this software. That is a very complicated system.

I'll dig into it, and learn what I have to do to fix my issue.

Thank you Very much for the tips!, and the database.

Link to comment
Share on other sites

This topic is 7397 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
  • Create New...

Important Information

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