Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006

    Referral Tracking System Design

    I'm very new to database design so there may be a very simple solution that i just cant see.

    I am trying to build a simple referral tracking system

    I am using filemaker

    The challenge i have is how to link the referrer to the referree. As i understand it, it is a one (referrer) to many (referrees) relationship. but both the referree and the referrer are customers in the same table.

    what i want is in the customer table, to be able to select the referring customer and for the referring customers record to have a list of all the other customers that they referred.

    thanks in advance for your help.

  2. #2
    Join Date
    Dec 2003
    I don't know if filemaker supports it, but what you want is a recursive relationship.

    Customer(customerID, referrerID, CustomerName ...)

    In this table the referrerID would be the customerID of the referrer of the customer. This creates a hierarchical chain of relationships within the same table.

  3. #3
    Join Date
    Oct 2006


    Thanks a lot for your help

    That was exactly what i needed to know. It works perfectly in Filemaker

    thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts