Munchie Posted April 9, 2004 Share Posted April 9, 2004 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 More sharing options...
Ugo DI LUCA Posted April 9, 2004 Share Posted April 9, 2004 Hi, True this is a complex relationship. At first, I would see it as a recursive relationship, so check this thread HTH FileMaker Version: 6 Platform: Mac OS 9 Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted April 9, 2004 Share Posted April 9, 2004 Hi, 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 MulltiLevelsRef.fp5.zip Link to comment Share on other sites More sharing options...
Munchie Posted April 11, 2004 Author Share Posted April 11, 2004 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 More sharing options...
Recommended Posts
This topic is 7318 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 accountSign in
Already have an account? Sign in here.
Sign In Now